Zeoslib Portal

Posted: **27.11.2017, 18:11**

Hi,
I have a problem with the Boolean fields of Firebird 3.0.
I use Code Typhon Ver. 6.30 on Windows 10 64.
I have created a database with the following table:

Code: Select all

CREATE TABLE TEST_TABLE (
BOOLEAN_FIELD BOOLEAN NOT NULL,
OTHER_FIELD SMALLINT NOT NULL);

In CT I create a Form on which I add ZConnection and ZReadOnlyQuery components. The ZReadOnlyQuery SQL is: 'SELECT * FROM TEST_TABLE'

In the field editor the BOLEAN_FIELD field instead of being TBooleanField is TStringField type as can be seen from the attached image.
Is it a Zeosdbo bug?

Thank you

Posted: **28.11.2017, 09:05**

Confirmed in DXE2. I'll check this.

Posted: **28.11.2017, 10:32**

I noticed that if the SQL is

Code: Select all

SELECT OTHER_FIELD, BOOLEAN_FIELD FROM TEST_TABLE

the field types, in the field editor, are correct

Posted: **28.11.2017, 14:37**

Check r4063, the issue should be fixed

Posted: **29.11.2017, 00:47**

Zeoslib Portal

Firebird 3.0 and Code Typhon: Boolean field error in Field Editor

Firebird 3.0 and Code Typhon: Boolean field error in Field Editor

Re: Firebird 3.0 and Code Typhon: Boolean field error in Field Editor

Re: Firebird 3.0 and Code Typhon: Boolean field error in Field Editor

Re: Firebird 3.0 and Code Typhon: Boolean field error in Field Editor

Re: Firebird 3.0 and Code Typhon: Boolean field error in Field Editor