Wildcard with Parameter
Wildcard with Parameter
(OP)
Hi,
Enviroment: WF Dev studio 5.2
If I want to see all the employees whose lastname starts with "S", I did the following thing:
WHERE LAST_NAME EQ 'S$*';
This is working fine.
Now, I want to prompt the user the first letter of the employee's lastname, I did in the following way:
WHERE LAST_NAME EQ '&LNAME$*'; ("LNAME" is the parameter)
This thing doesn't work !!!
Please help me.
Regards
WFRAJ
Enviroment: WF Dev studio 5.2
If I want to see all the employees whose lastname starts with "S", I did the following thing:
WHERE LAST_NAME EQ 'S$*';
This is working fine.
Now, I want to prompt the user the first letter of the employee's lastname, I did in the following way:
WHERE LAST_NAME EQ '&LNAME$*'; ("LNAME" is the parameter)
This thing doesn't work !!!
Please help me.
Regards
WFRAJ
Talk To Other Members
RE: Wildcard with Parameter
Try this.
WHERE LAST_NAME EQ '&LNAME.EVAL$*'
or
WHERE EDIT(LAST_NAME,'9') EQ '&LNAME'
Can these work in your enviroment?
sim
RE: Wildcard with Parameter
Its working.
I appreciate your help.
I am new to WF and I would need the help of people like you.
Thank you very much
regards
WFRAJ
RE: Wildcard with Parameter
-SET &LNAME = &LNAME | '$*';
TABLE FILE ...
...
WHERE LAST_NAME EQ '&LNAME'
Sometimes WebFOCUS will offer you a few solutions to your problems. We're using a similar method to allow for "optional parameters" if anyone is interested:
-SET &LNAME = IF &LNAME2 EQ ' ' THEN '$*' ELSE &LNAME2
WebFOCUS propmts the user for LNAME2, then uses LNAME in the WHERE. If LNAME2 is blank, the report selects all names.
Regards,
Michael
RE: Wildcard with Parameter
Even your thing works !!
Thankyou very much.
regards
WFR