Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
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.
- Posts: 2098
- Joined: Tue 14 Feb 2006 10:14
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.
I set this field to autoincfield manually and works well.
- Posts: 186
- Joined: Wed 03 Nov 2004 16:57
- Location: Spain
Another good solution is RefreshRecord after a post.