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

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Hanne Berthelsen
Posts: 15
Joined: Thu 18 Nov 2004 07:51

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

Post by Hanne Berthelsen » Tue 01 Mar 2005 18:00

I am using MyDAC v. 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

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 02 Mar 2005 09:03

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.

Post Reply