SETRANGE or SETFILTER for "Not Empty" fields

Isaland

Hello guys. I have one small question.
There is a Code DataType Field which i need to sort.
But i can`t find how to make SETRANGE or SETFILTER for "no empty" value

P.s. Field is No. of payroll order. And i need to sort records, where "Order No." is "no empty"

bbrown

I vote for:

Setfilter("Order No.",'>%1','') ;

Help avoid an index scan.

Isaland

#-o

MiscCardsData.SETFILTER("Order No.",'>0');

dans

SETFILTER(Field,'<>%1','')

MBerger

I'd use

Setfilter("Order No.",'<>%1','') ;

bbrown

I vote for:

Setfilter("Order No.",'>%1','') ;

Help avoid an index scan.