Subject Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?
Author Artur Anjos

> At 11/22/2001 12:20 AM (Thursday), Geoff Worboys wrote:
> >There is nothing insane or even technically difficult about
> >maintaining an unbroken sequence. Attempting to use such a solution
> >where it is not required (such as generated key values) may be
> >somewhat crazy, but there are places where unbroken sequences are
> >required.

Doug Chamberlin wrote:
> Any examples you can think of?

In Portugal, we must keep them for invoice numbers, for example. Any legal
document should have a 'unbroken sequence'. But this is never related to
generated key values.

In Jason's web site the re is a document that help people think about this
inside transactions. What I do for getting this sequential numbers could be
resume like this: 'Open Transaction, Set temporary value to that field (a
negative value), Post it, Close Transaction'. No Data Validation Errors?
'Open Transaction, Set Value, Close Transaction'. (It's more complex that
this - I'm resuming).

Artur Anjos