Filtering rows that have empty field

Kaitsu · 2006-06-06

I am trying to filter all the rows from table that has empty date field.
I tried this:
recTable.SETFILTER("Export date", '');
but looks it just resets the filter and returns all the rows.
Is it possible to filter rows with empty date (or string) field at all?

DenSter · 2006-06-06

For a blank date you should do:

recTable.SETRANGE("Export date",0D);

in general though, you can do:

recTable.SETFILTER("Export date",'=%1','');

kine · 2006-06-07

Or

recTable.SETRANGE("Export date",'');  //SETRANGE instead SETFILTER... :-)

Filtering rows that have empty field

Comments

Categories