Setfilter - blank option

sabzam

Hi everyone,

What is the correct syntax to filter a blank option ?

Thanks

anniqa

'' ( i e empty string)

sabzam

anniqa wrote:

'' ( i e empty string)

Was already tested and does not work.

bab

You mean like the Type field in the Sales Line table?
Then you can filter like this:

SalesLine.SETRANGE(Type, SalesLine.Type::" ");

awarn

Maybe you mean you do you deal with a filter that may or may not be blank?

//variable DateFilter holds a string like 10/1/2007..11/1/2007 - or it might be blank

CustLedgerEntry.reset;
CustLedgerEntry.setcurrentkey ( set the proper key
...
if DateFilter <> '' then
CustLedgerEntry.setfilter("Posting Date",DateFilter)
else
CustLedgerEntry.setrange("Posting Date");


-a