Setfitler Problem

sabzam

Dear All,

I am looking in a table using setfilter. It is working properly except for one case...when the data used as filter is 0 as test i.e. '0'; an error is being realeased stating that there is no record with field ''. The ambigous thing is that '' is never passed over but a '0' is passed besides there is an if statement to the find.

Has anyone got any idea why this may be happening?

jsnayberk

Did you try this?
SETFILTER("Name 2", '=%1', '');

Regards

sabzam

Actually I have got the same coding but less specific; in other words I do not want to specifically look for '' but simply that when one of the fields used as setfilter is '' no error message is displayued but simply the next field is requested by the codeunit

jsnayberk

I´m not sure I understood correctly what you are trying.
Could you, for illustration, post a code sniplet with some comments of what is working an what not?