MySQL Forums
Forum List  »  Delphi

autoincrement does not working correctly in MySQL innoDB 5.1
Posted by: John Kuiper
Date: December 18, 2009 05:15AM

For weeks now I'm trying to get clientdataset work with MySQL. Last time I followed this article: http://edn.embarcadero.com/article/20847

For Clientdataset it's working an will not give duplicate keys.
But MySQL will not convert the autoincrement correctly. Because the key has a negative result and the value is not NULL, the key value will be inserted into the autoincrement field instead of genereated by MYSQL.

So far as I can see, MYSQL generates only an ID when the key value is NULL.

Is this a bug in MySQL and is there a workaround for it.

Options: ReplyQuote


Subject
Written By
Posted
autoincrement does not working correctly in MySQL innoDB 5.1
December 18, 2009 05:15AM


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.