setfilter for remaining quantity >0

monir_asian

I need a filtering field in itemledger entry table where remaining quantity >0
setfilter(remainingquanatity,'>%1',0);
setfilter(remainingquanatity,'>0');

which one is correct?

Luc_VanDyck

You should use the 1st notation ... but correct the fieldname ;-)

kriki

Actually both work in this case, but the first always works.

thegunzo

You might want to select a key with the Open field included and use SETRANGE(Open,TRUE) before this filter to speed things up.