Hi,
I have a Time Log database using H2 with LibreOffice Base as the front end.
The TimeLog Table's Key is -
TimeLogID BigInt[IDENTITY]
This automatically assigns the next number for each new record. It works
well for several records, then it suddenly jumps by 30 or 31 for no
apparent reason.
I can edit the table to correct the number and then run the SQL Command -
ALTER TABLE TimeLog ALTER COLUMN TimeLogID RESTART WITH 7737
to re-sync the TimeLogID to where it should be for the next record.
I could write macro code to detect this problem and do the above steps
automatically, but I though it would be much better if I could find out how
to prevent it happening in the first place.
Any suggestions for a cure?
Thanks,
Noel
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
