setrange <>, how is it possible?

stan · January 30, 2008, 1:07pm

for example we don’t want field “NKS No.” that is empty

how to setrange it?

thanx for the answer…

federico.bacile · January 30, 2008, 1:16pm

Record.SETFILTER(“NKS No.” ,’<>%1’,’’);

Bye bye

babrown · January 31, 2008, 12:25pm

Avoid the use of “not equal to” if using the SQL database. It results in table scans and can impact performance.

Record.SETFILTER(“NKS No.” ,’>%1’,’’);

stan · February 1, 2008, 2:02am

ok, thanks for the answer

case closed !