Filter on Blank Records

upasanisandip

Hi,
I want to filter on "Form No." column where Form no. is blank
What is wrong in folloing syntax. Giving me error.

Rec.SETFILTER("Form No.",'=''');

Thanks.

stryk

You should use this instead:

Rec.SETFILTER("Form No.", '=%1', '');

kriki

better use SETRANGE instead of SETFILTER. Use only SETFILTER if you have no other possibility.

SETRANGE("Form No.",0); //integer/decimal
or
SETRANGE("Form No.",''); //text/code