MySQL Forums
Forum List  »  Connector/ODBC

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.

Options: ReplyQuote


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.