Solved problem:
if ((not dat_fecha is null) and (not dat_fec is null)) then

Thanks
=========
|| ISMAEL ||
=========

----- Original Message -----
From: Ismael L. Donis García
To: firebird-support@yahoogroups.com
Sent: Tuesday, April 27, 2010 10:02 AM
Subject: [firebird-support] record of date has void value or no (fb 2.1.3)



As I could find out if a record of date has void value or no.
I try, but give error:

select alminv.fecha, alminv.fconteo from alminv where ((alminv.entidad = :vch_entidad) and (alminv.almacen = :sin_almman) and (alminv.codigo = :vch_cod)) into :dat_fec, :dat_fcont;
if (row_count > 0) then
begin
if ((dat_fec not is null) and (dat_fcont not is null)) then /* Here give the error */

Thanks
=========
|| ISMAEL ||
=========

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]