The following properties are not set correct when a tMyQuery is opend:
FieldDefs[].DataType;
FieldDefs[].Precision;
FieldDefList[].DataType;
FieldDefList[].Precision;
-----
GetDataType
GetFieldPrecision
Bug (or limitation) in MyDac ?
When the property's are accessed, the values are wrong. Only the name property works correct. For example:Dimon wrote:Please describe the problem in more details.
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.