Devart Forums

Hi all. I am using (copied out of the readmen)
MySQL Data Access Components 3.50

and delphi 6.
I have been trying to use a myquey componetnt but by adding the sql staement at run time and then using the builder option and the following code

select *
from faults
where pcontractor = 1

and I get an Unknown MySQL datatype (246) (D:\Projects\Delphi\MyDac\Source\MyClasses.pas, line 878).

But if I copy the same sql staement to a gui front end

DBACentral Manager for MySQL by MicroOLAP

it runs fine. Same database etc. no other changes.
Its driving me nuts. I am new to SQL etc so can anyone shead some light on the error pls

Please check what version of MySQL Server do you use. MyDAC 3.55 does not have full support of MySQL Server 5.0. Try to download MyDAC 4 from our site to test this issue.

I had a similar problem with a table that had about 40 columns.

I discovered that the error only came up when a field of "Decimal" existed. As soon as I removed that feild it worked.

I played with it for a while, trying to get it to work but I couldn't.

Anybody else having this trouble and your table has a decimal field try removing it.

`Cost` decimal(10,2) is the field definition we were using.

Thank you for information. What the versions of MySQL Server and MyDAC do you use?

The version I have is 3.50.0.17 and I am using Delphi 7 Enterprise.

I have been told there is a later version, but because I can't remember any of my purchase details I can't download it. But who needs a decimal anyway?

Craig

The DECIMAL field type support was added to MyDAC 3.50.0.19, so you are required to use this or either of later releases of MyDAC to work with the DECIMAL field type.

> but because I can't remember any of my purchase details I can't download it.
Please try to contact our sales team (sales*crlab*com).