Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

Hello Luigi If you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/09/11/algo-mas-sobre-transacciones-optimistas-y-transacciones-pesimistas/ Greetings. Walter. On Thu, Dec 24, 2015 at 7:05 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support]

Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

Also, take a look at this ancient document that used to be the standard answer to people asking the same question as yours: http://ibobjects.com/docs/ti_AuditableSeries.ZIP HTH, Set 2015-12-22 20:26 GMT+01:00 Ann Harrison aharri...@ibphoenix.com [firebird-support]

Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

On Tue, Dec 22, 2015 at 9:40 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > >I must assign a serial number, without hole, in a column of a fiscal > document. I must assign the number only when I know if the document is > complete >

[firebird-support] Numeration without hole, Is right Before Insert Trigger?

Hello, I must assign a serial number, without hole, in a column of a fiscal document. I must assign the number only when I know if the document is complete and I think the right moment is on a Before Insert Trigger for the table. Is right or the insertion can fail? If not right, when I must