Question:
HI All,
I want to default a wildcard into a select option but when I do the wildcard acts as a literal.
Select-option s_table for dd02l-tabname default 'Z*'.
Unfortunately this looks for a table equal to Z* not all tables beginning with a 'Z'.
Any ideas?
Thanks
Answer:
Yes, do the following:
Type in Z* into a select option field when running the program (without a default), and put a break-point in your code. Look at the select-option table. Note the value of the 'option' field is not 'EQ' but something else like 'PT' (I think), this means the select statement will read this as a pattern ...
Answer:
wildcard is LIKE 'Z%'. It is all explained in the help on the WHERE clause
_________________
Only sheep and Tuly Idiots need a leader
Answer:
Excellent, many thanks.
NB option was CP.
Answer:
Excellent, many thanks.
NB option was CP.
Answer:
Eelco - you're wrong. Wildcards are * and + (any number of chars or just one, respectively) in select-options and ranges. When used in a select with LIKE they are % and _.