Error: Unknown Mysql datatype (246)

agouveia · Post by **agouveia** » Fri 23 Nov 2007 16:32

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

Antaeus · Post by **Antaeus** » Mon 26 Nov 2007 12:16

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.

agouveia · Post by **agouveia** » Mon 26 Nov 2007 15:09

Hello,

Where can i download?

Best Regards,
Antonio

Antaeus · Post by **Antaeus** » Mon 26 Nov 2007 16:26

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

cecepoche · Post by **cecepoche** » Sun 02 Mar 2008 13:53

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

cecepoche · Post by **cecepoche** » Sun 02 Mar 2008 14:02

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

Thank You
- Yoseph

eduardosic · Post by **eduardosic** » Sun 02 Mar 2008 15:27

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

cecepoche · Post by **cecepoche** » Mon 03 Mar 2008 04:19

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

Dimon · Post by **Dimon** » Tue 04 Mar 2008 12:27

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.

cecepoche · Post by **cecepoche** » Wed 05 Mar 2008 11:08

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

Thanks for your help.
-Yoseph

Dimon · Post by **Dimon** » Wed 05 Mar 2008 13:58

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