Filter form with an asterix

slmaluwa

Hi
Is it possible to filter a form on open with a condition like

Show only records with "No." not starting with 'X'

SETFILTER(COPYSTR("No.",1,1),'<>X');

and put this filter in FILTERGROUP(2) ?

If not is there a work around for this? Client insist on have two forms display table based on first character of the "No." field. One for starting with 'X' and other for the rest.

TIA

kine

1) Learn how to use SETFILTER
2) Yes, it is possible...


e.g.

SETFILTER("No.",'<>%1*','X');
or
SETFILTER("No.",'%1*','X');

But it works only for SQL option...

slmaluwa

kine wrote:

But it works only for SQL option...

Thank you Kine for a new knowledge.
I understand the reason why it didn't work for me before?
The client is on Native DB with 4.0SP3.

Need to look for a workroung, then?

kine

Yes, even when it works I will look for another way. It looks like the X on beginning have some meaning. Why there is no field for this "meaning"? Than you can filter on this....