| Subject | Re: [firebird-support] Re: Sequential auto incremental numbering |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-09-03T09:38:55Z |
03.09.2018 8:29, 'Christian Giesen' chris@... [firebird-support] wrote:
INSERT and avoid updating of just inserted record.
To get strictly sequential numbers you must use non-database remedies. For example, a
paper book for invoice registration.
--
WBR, SD.
> 2.I have implemented an AFTER INSERT trigger on the INVOICE table as follows:You trigger can work in single user environment only. BTW, it is better to be BEFORE
INSERT and avoid updating of just inserted record.
To get strictly sequential numbers you must use non-database remedies. For example, a
paper book for invoice registration.
--
WBR, SD.