Subject | Generator values not udpated |
---|---|
Author | Ed Dressel |
Post date | 2008-11-06T19:02:17Z |
FB 1.5 Embedded.
I have some pretty easy to understand code where I get a generator
value and insert a new record in a table--I do this for various
tables. I am using Delphi and IBO, and here is an example:
lPersonID := FIBConn.Gen_ID('GEN_PERSON_ID', 1);
where lPersonID is an integer, and FIBConn is a TIBODatabase.
Multiple inserts happen to each table and the ID's fr the new records
are exactly what I would expect.
But occasionally, the values for the generators are reverted back to
their values were updated--the values in the tables are correct, it's
just the generators that are not correct. There is no rollbacks (and
even if there was, the generators shouldn't be rolled back, right?).
It ends up causing major headaches for me.
Any ideas on what might cause this?
THank you,
Ed Dressel
I have some pretty easy to understand code where I get a generator
value and insert a new record in a table--I do this for various
tables. I am using Delphi and IBO, and here is an example:
lPersonID := FIBConn.Gen_ID('GEN_PERSON_ID', 1);
where lPersonID is an integer, and FIBConn is a TIBODatabase.
Multiple inserts happen to each table and the ID's fr the new records
are exactly what I would expect.
But occasionally, the values for the generators are reverted back to
their values were updated--the values in the tables are correct, it's
just the generators that are not correct. There is no rollbacks (and
even if there was, the generators shouldn't be rolled back, right?).
It ends up causing major headaches for me.
Any ideas on what might cause this?
THank you,
Ed Dressel