AutoIncFields are not set automaticly

trying · Post by **trying** » Sun 19 Feb 2006 10:59

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

Antaeus · Post by **Antaeus** » Mon 20 Feb 2006 09:16

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.

trying · Post by **trying** » Mon 20 Feb 2006 09:20

Ok.

I set this field to autoincfield manually and works well.

Regards

GEswin · Post by **GEswin** » Mon 20 Feb 2006 21:48

Another good solution is RefreshRecord after a post.