Float field default value problem

Float field default value problem

Postby guest » Tue 02 Aug 2005 04:51

I am using MyDAC 4.00.0.1 and MySQL 4.0.23-nt on WinXP.
In my database I have a table defined as following:

CREATE TABLE test (
field1 float NOT NULL default '0.5'
) TYPE=MyISAM;

The following code in C++ Builder 6.0 :

MyQuery->Options->DefaultValues = true;
MyQuery->SQL->Text = "select * from test";
MyQuery->Open();
MyQuery->Insert();

produces an exception with message:
''0.5' is not a valid floating point value for field 'field1''.

Is there any way to solve this problem without changing the system decimal separator?
guest
 

Postby Ikar » Tue 02 Aug 2005 09:55

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components