Page 1 of 1

AutoIncFields are not set automaticly

Posted: Sun 19 Feb 2006 10:59
by trying
Hello,

I am still testing MyDAC.

I C++Builder 6 pro + MySQL 4.1.16
I have a master key:

INTEGER + AUTOINCREMENT and when I use fields editor for retrieve all fields in table this key is set with TIntegerField.

Regards

Posted: Mon 20 Feb 2006 09:16
by Antaeus
It is normal behaviour. Because AUTO_INCREMENT keyword doesn't determine field data type at all, it only means that default value for the field will be calculated and set by the server. Note that MySQL Server allows setting values of the fields, defined as AUTO_INCREMENT, manually.

Posted: Mon 20 Feb 2006 09:20
by trying
Ok.

I set this field to autoincfield manually and works well.

Regards

Posted: Mon 20 Feb 2006 21:48
by GEswin
Another good solution is RefreshRecord after a post.