Hello,

on Firebird 2.5.2.26539 we have the following domain in our database:

CREATE DOMAIN BOOLEAN AS
 SMALLINT
 DEFAULT 0
 NOT NULL
 CHECK (VALUE IN (-1, 0))
;

With IBObjects version 5.9.7 [Build 2754] there seems to be a problem with such a domain. When editing a record, where a boolean field has a correct value of 0, the following error occurs when saving the changes:

[...]validation error for column MYCOLUMN, value "*** null ***"[...]

When inserting a new record, I do

myIBOQuery.Append;
myIBOQueryMYCOLUMN.AsInteger := 0; (it's already set to 0 anyway because of the default value in the declaration)
myIBOQuery.Post;

but the same error occurs here as well.

Doing both actions directly in DatabaseWorkbench, for instance, works fine.

I think it was already faulty in version 5.9.5 [Build 2652], but happened not that often there, i.e. mostly it seemed to work. However, with the current version the error occurs where it shouldn't.

Best regards,
Patrick