Board index » delphi » D6 sqldataset -MySQL with auto_increment field

samirastl

Delphi Developer
Fri, 29 Apr 2005 00:21:07 GMT

D6 sqldataset -MySQL with auto_increment field

I have D6 SQLDataset connect to MySQL ; primary key(OrderNO) in MySQL is
auto_increment field

Dataset -SQLProvider-Clientdataset . Persistent field in clientdataset
property "AutoGenerateValue" is set to "arAutoInc"

when applyupdates(0) , I got the error OrderNO ( the auto_increment field)
must have value.

How do I fix this ?
Many thanks

 
Aaron Milne

Delphi Developer
Sat, 30 Apr 2005 23:59:15 GMT

Re:D6 sqldataset -MySQL with auto_increment field


Did you make the field marked has not required in the SQLDataset?

Other Threads

1. MySql auto_increment field

2. dbExpress does not supprot mySQL AUTO_INCREMENT primary key ???

3. mySQL and auto_increment values

4. mysql + auto_increment

5. Show SQLDataSet (dbExpress D6) in Dbgrid or TDBCtrlGrid ??

6. Error in SQLDataSet with Calculated field - problem with first record

7. SQLDataSet CommandText Editor does not show my tables and fields (dbExpress + SQLServer)

8. Problems with Comma in Memo Fields & SqlDataset

9. MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

10. MySql-AUTO_INCREMENT field don't increment in Delphi...