help with staement

peter · Post by **peter** » Sun 17 Sep 2006 05:44

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

Antaeus · Post by **Antaeus** » Tue 19 Sep 2006 12:42

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.

captainrproton · Post by **captainrproton** » Fri 08 Dec 2006 05:25

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.

Antaeus · Post by **Antaeus** » Fri 08 Dec 2006 07:55

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

captainrproton · Post by **captainrproton** » Sat 09 Dec 2006 19:17

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

Antaeus · Post by **Antaeus** » Mon 11 Dec 2006 15:21

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).