Subject | Re: [IBO] Still little problems |
---|---|
Author | Salvatore Besso |
Post date | 2003-03-16T12:06:06Z |
hello Daniel,
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
> You can set that field property(BlankIsNull)This is the IB_Monitor response with BLANKISNULL *not checked* for
> in TIB_Query, via the query editor.
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