MyTable->Post() problems for MySQL v. 4.1.8

[Hanne Berthelsen]

I am using MyDAC v. 3.30.2.15 for Builder 5.

I have a table with the following fields:

UniqNr smallint(6)
ZoneNr smallint(6)
Description char(40)
Shape smallint(6)
Type smallint(6)
Value1 decimal(25,15)
Value2 decimal(25,15)
Value3 decimal(25,15)
Value4 decimal(25,15)
Value5 decimal(25,15)

I have an index that contains all fields.

MyTable->Post() doesn't work when updating records when I am using MySQL v. 4.1.8. No problems if using MySQL v. 4.0.17.

Have you got any idea of what is wrong ?
Would it help to upgrade to latest version of MyDAC ?

Please let me know if you want an example application!

Regards Hanne

[Ikar]

The cause of the problem may be using DECIMAL as key field. From the point of view of optimal execution DML-queries it will be correct to add an unique autoincrement field at each table.