Delete restart autoincrement field
Posted by:
Ale San
Date: March 29, 2010 06:47AM
Hi
I have a sotfware developed in Delphi 7 with mysql 4.0.17-nt and ODBC 3.51.22. The system has tables with autoincrement property is their primary keys. So, my error is: after I deleted all the rows of the tables, the autoincrement value is restarted!! Im sure that Im using delete instead of truncate.
Why is happening this?
I did some tests and I decided to change the ODBC version to 3.51.26 and the problem was solved.
Has the ODBC 3.51.22 a bug?
Thanks
Edited 1 time(s). Last edit at 03/29/2010 06:50AM by Ale San.
Subject
Written By
Posted
Delete restart autoincrement field
March 29, 2010 06:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.