chee hee wrote:

> Hi All,
>
> I am thinking to use a generator for invoice number in my application.
> Any idea/code on how to generate auditable invoice number, meaning we CANNOT have a break in invoice number in invoice table.

Don't use generators - by design they're not auditable. Even if
you follow all the suggestions about acquiring them, a system crash
can leave holes. Create your own transactional mechanism instead.

As suggested earlier, look here:
http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries


Regards,


Ann