Devart Forums

Hello...

I have MYDAC 3.50.0.18 working in delphi5.

Yesterday I switch my mysql database from 4.0.23 to mysql 5.0.45

My applications start giving problems with some Query's giving error:
Unknown MySQL datatype (246) (D:\projects\delphi\mydac\source\myclasses.pas, line 867)

Could you help me with this problem?
What changes should i do in my code?
Should i made same changes in DATABASE?

Thank You,
Antonio Gouveia

In the recent builds of MyDAC 3 support for DECIMAL and BIT data types were added. Try to download and install the last build of MyDAC 3 (3.55.0.26). It should solve the problem.

Hello,

Where can i download?

Best Regards,
Antonio

You can download it from the registered users' area of our site. Please see your registration e-mail for details.

I have mydac 2.00.3.10.

When I do query like this "Select name, sum(field1), sum(field2) from tabel group by name", there is error message "Unknown Mysql Datatype (246): (D:\project\delphi\mydac\source\myClasses.pas, line 646).

but if i change the query like this "select * from tabel", there is no error.

How can I handle error like this ??
Could you help me !

-Yoseph

For more information I am using delphi 6 and the the component I use is MyQuery.

Thank You
- Yoseph

cecepoche wrote:For more information I am using delphi 6 and the the component I use is MyQuery.

Thank You
- Yoseph

provide more information for Corelab Support.

MySQL Server Version.
Delphi or C++ Builder Version.
Data Type of Field1 and Field2 in table

I am using delphi 6 Enterprise Version 6.0 ( Bulid 6.163)
Mysql Version : 4.1.10a-nt.
Field1, Field2 .. Datatype:Bigint 20 for representing currency..

We can not reproduce the problem.
Please send a complete small sample to dmitryg*crlab*com to demonstrate it, including script to create and fill table.

I think I have solved the Problem...
I Change Myql version...

Thanks for your help.
-Yoseph

It is good to see that this problem has been solved.