Conversion error from string BOOLEAN
Posted: Wed 27 May 2015 15:43
Hi,
I got a very weird case. I can build/run my old projects smoothly using IBDAC ver 4.1.4.
When i try new version 5.4.13, It cannot run anymore, it will always shows
"Conversion error from string BOOLEAN"
After a few days i managed to reproduce it. here's how
Create table in your database
CREATE DOMAIN T$BOOLEAN AS
SMALLINT
DEFAULT 0
NOT NULL;
CREATE TABLE t1 (
ID integer default 1 NOT NULL primary key,
CODE varchar(32),
DESCRIPTION varchar(64),
O_EXCEL T$BOOLEAN,
O_SUMMARY T$BOOLEAN
) ;
insert into t1(id)
values(1);
And create delphi app, i use delphi 7,
IBCQuery i set BooleanDomainFields and defaultValues checked in Options.
tdbcheckbox and button to post it.
Run check true and post it, error.
Hope fixed asap
Thanks
I got a very weird case. I can build/run my old projects smoothly using IBDAC ver 4.1.4.
When i try new version 5.4.13, It cannot run anymore, it will always shows
"Conversion error from string BOOLEAN"
After a few days i managed to reproduce it. here's how
Create table in your database
CREATE DOMAIN T$BOOLEAN AS
SMALLINT
DEFAULT 0
NOT NULL;
CREATE TABLE t1 (
ID integer default 1 NOT NULL primary key,
CODE varchar(32),
DESCRIPTION varchar(64),
O_EXCEL T$BOOLEAN,
O_SUMMARY T$BOOLEAN
) ;
insert into t1(id)
values(1);
And create delphi app, i use delphi 7,
IBCQuery i set BooleanDomainFields and defaultValues checked in Options.
tdbcheckbox and button to post it.
Run check true and post it, error.
Hope fixed asap
Thanks