| Subject | Re: [firebird-support] record of date has void value or no (fb 2.1.3) |
|---|---|
| Author | Helen Borrie |
| Post date | 2010-04-27T19:09:58Z |
At 05:57 AM 28/04/2010, you wrote:
if ((dat_fecha is not null) and (dat_fec is not null)) then
i.e., <field> IS NOT NULL is valid syntax, <field> NOT IS NULL is invalid.
./heLen
>Solved problem:To avoid negatives:
>if ((not dat_fecha is null) and (not dat_fec is null)) then
if ((dat_fecha is not null) and (dat_fec is not null)) then
i.e., <field> IS NOT NULL is valid syntax, <field> NOT IS NULL is invalid.
./heLen