Subject Re: [firebird-support] record of date has void value or no (fb 2.1.3)
Author Helen Borrie
At 05:57 AM 28/04/2010, you wrote:
>Solved problem:
>if ((not dat_fecha is null) and (not dat_fec is null)) then

To avoid negatives:

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.