Bug (or limitation) in MyDac ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kaffeburk
Posts: 214
Joined: Mon 29 Jan 2007 08:03

Bug (or limitation) in MyDac ?

Post by kaffeburk » Tue 05 Aug 2008 16:31

The following properties are not set correct when a tMyQuery is opend:

FieldDefs[].DataType;
FieldDefs[].Precision;
FieldDefList[].DataType;
FieldDefList[].Precision;
-----
GetDataType
GetFieldPrecision

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 06 Aug 2008 12:05

Please describe the problem in more details.

kaffeburk
Posts: 214
Joined: Mon 29 Jan 2007 08:03

Post by kaffeburk » Wed 06 Aug 2008 12:25

Dimon wrote:Please describe the problem in more details.
When the property's are accessed, the values are wrong. Only the name property works correct. For example:

s:= myQuery.FieldDefList[0].Precision;

will always return 0 if Field[0] is a varchar. I guess MyDac don't need this information internally and therefore never sets the properys when a query is opened. The fieldnames it does need, and therefore sets them correct. Im not 100% sure the datatype sets correct or not - but the precision definetly does not.

Just try to get the precision out of a field in a query and you will see it dosent work.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 08 Aug 2008 06:20

The TFieldDef.DataType property is always set correctly. About the Precision property we have answered you in another thread.

Post Reply