Can I pass the value is null
or is not null
through a Query?
Example in SQL:
select * from tb_teste where tb_teste.data_hora :PARAMETRO;
In Delphi:
Query.ParamByName('PARAMETRO').value = 'is not null';
or
Query.ParamByName('PARAMETRO').value = 'is null';
Note: the data_time field is a Timestamp, I am using Firebird database.