Subject | Re: why reset all generators? |
---|---|
Author | Sasa Mihajlovic |
Post date | 2008-04-02T14:59:16Z |
Hi,
I have procedure that pass all generators, get max(id) from table
connected to generator and set generator value. This is good procedure
when empy table or delete a lot of records or deploy same database to
another user with empty documents table, etc...
It is not a bad idea to reset generators, I have a specific problem
with fiscal printers which is limited by number of aticles and I'm
using id for fiscal printer id (for example).
Sintax is: SET GENERATOR GENERATOR_NAME TO NEW_VALUE
I have procedure that pass all generators, get max(id) from table
connected to generator and set generator value. This is good procedure
when empy table or delete a lot of records or deploy same database to
another user with empty documents table, etc...
It is not a bad idea to reset generators, I have a specific problem
with fiscal printers which is limited by number of aticles and I'm
using id for fiscal printer id (for example).
Sintax is: SET GENERATOR GENERATOR_NAME TO NEW_VALUE