Subject Re: [IBO] Still little problems
Author Salvatore Besso
hello Daniel,

> You can set that field property(BlankIsNull)
> in TIB_Query, via the query editor.

This is the IB_Monitor response with BLANKISNULL *not checked* for
field DESCRIPTION:

/*---
EXECUTE STATEMENT
TR_HANDLE = 14498380
STMT_HANDLE = 14499676
PARAMS = [ Version 1 SQLd 5 SQLn 5
[DESCRIPTION] = <n> ''
[EXPIRY_DATE] = '16 mar 2003'
[ALERT_DAYS_BEFORE] = 1
[ALERT_DAYS_AFTER] = 1
[EVENT_ENABLED] = 1 ]

INSERT COUNT: 1
----*/

And this is the IB_Monitor response with BLANKISNULL *checked* for
field DESCRIPTION:

/*---
EXECUTE STATEMENT
TR_HANDLE = 14505104
STMT_HANDLE = 14499676
PARAMS = [ Version 1 SQLd 5 SQLn 5
[DESCRIPTION] = <n> ''
[EXPIRY_DATE] = '16 mar 2003'
[ALERT_DAYS_BEFORE] = 1
[ALERT_DAYS_AFTER] = 1
[EVENT_ENABLED] = 1 ]

INSERT COUNT: 1
----*/

As you can see there are no much differences... <g> And, NOT. There is
no default value for field DESCRIPTION.

Regards
Salvatore