Conversion error from string BOOLEAN

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
seberaya
Posts: 5
Joined: Sat 17 Oct 2009 14:11
Location: brastagi

Conversion error from string BOOLEAN

Post by seberaya » 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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Conversion error from string BOOLEAN

Post by ViktorV » Thu 28 May 2015 09:51

Unfortunately, we couldn't reproduce the problem in the way you have described: updates were saved correctly with no errors. Please send a small sample demonstrating the problem to viktorv*devart*com, including the script for filling in the database objects.

seberaya
Posts: 5
Joined: Sat 17 Oct 2009 14:11
Location: brastagi

Re: Conversion error from string BOOLEAN

Post by seberaya » Fri 29 May 2015 02:39

Hi,

I have sent a sample project to reproduce it.
Please review

TIA

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Conversion error from string BOOLEAN

Post by ViktorV » Fri 29 May 2015 07:59

Thank you for the information. We have reproduced the problem and investigation is in progress. We will inform you when we have any results.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Conversion error from string BOOLEAN

Post by ViktorV » Tue 23 Jun 2015 09:36

The new IBDAC build with a fix for the "Conversion error from string BOOLEAN" bug are available for download now.

Post Reply