Help! Any records that I create using the client-half of my client/server database don't increment their auto-increment fields! This creates key violations as the field in question is the primary key. What's going on?
Thanks,
Tim.
Wed, 18 Jun 1902 08:00:00 GMT
Christophe Dar #2 / 4
Auto-increment fields
Please let us know what database you are using. It could be useful to understand your problem.
I have seen the same problem when using an MS Access database via an ODBC connection (Delphi 4, MS Access ODBC driver 3.50.342800). I eventually set the autoinc field value in my Delphi code by treating it as a normal field and setting its value to 1 greater than the current max value, though this is not a good idea in a multi user environment as you will have errors if two users try to append a field at the same time.
Regards Dave Stubbington.
Quote:
>Help! Any records that I create using the client-half of my client/server >database don't increment their auto-increment fields! This creates key >violations as the field in question is the primary key. What's going on?