Filter with * (asterisk)

kalin

Hello

How to set filter on a form to find only this rows which description contains substring '*$*' ??

Wojtek

kine

you mean value including the asterisk?

Than you can try to use something like:

SETFITLER(MyField,'*%1*','*$*');

kalin

kine wrote:

you mean value including the asterisk?

Than you can try to use something like:

SETFITLER(MyField,'*%1*','*$*');

Yes, value include the asterisk.

Your proposition won't work in Nav 4.03 SQL.

Besides i need to put that filter on form (F7) not in code.

I'm almost shure that this is imposible i need confirmation.

kine

try to enter '*$*' (including aphostrophes)....

garak

you can use CTRL+F
Regards

kalin

garak wrote:

you can use CTRL+F

I dont wont to find. I wont filter my journal.

Right now i make function like this:

FindSubString()
IF COUNT = 0 THEN EXIT;

w.OPEN ('Enter Substring. #1#########\',subvalue);
w.INPUT(1,subvalue);

FINDFIRST;
REPEAT 
  IF STRPOS(Description,subvalue) > 0 THEN
    MARK(TRUE)
  ELSE
    MARK(FALSE);
UNTIL NEXT = 0;

MARKEDONLY(TRUE);

It's working but there should by simpler way.