[solved] ZEOS 7.2 and Firebird 3 Boolean fields

[abonic]

ZEOS 7.2.1-rc do not work with Firebird 3 Boolean fields because of error in ZDbcInterbase6Utils.pas procedure TZSQLDA.InitFields(Parameters: boolean);

Here is the fix:

Code: Select all

case SqlVar.sqltype and (not 1) of
  { bug fix start }
  SQL_BOOLEAN_FB, // it works now
  { bug fix end }
  SQL_BOOLEAN, SQL_TEXT, SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_DATE,
  SQL_BLOB, SQL_ARRAY, SQL_QUAD, SQL_SHORT,
  SQL_LONG, SQL_INT64, SQL_DOUBLE, SQL_FLOAT, SQL_D_FLOAT:
	IbReAlloc(SqlVar.sqldata, 0, Max(1, SqlVar.sqllen));
  SQL_VARYING:
	IbReAlloc(SqlVar.sqldata, 0, SqlVar.sqllen + 2)
end;

[Prometeus]

Hello,

I had the same problem with Zeos 7.3 SVN_3945 and Firebird 3.01. Boolean fields couldn't be recorded on database. I received the same error message and the above fix also worked.

Regards,
Joao Lira.

[marsupilami]

Just for the record: This got fixerd in Rev. 3943.