Wild Card/Generic retrieval
Landers, Dianne
DLanders@pcc-structurals.com
Tue, 9 Sep 2003 10:12:25 -0700
Running Unix 11.0, oracle 8.1.7, ph 8.23d7.
In the manual Powerhouse Rules, the section on using metacharacters, for
the generic character at sign(@), the function description:
Matches zero or more characters (alphabetic, numeric, or special).
Gives the example that I'm trying to use.....
The pattern "@th" matches any value ending with "th".
I'm trying to retrieve records by the following:
> Access partmaster
> Choose partno '@03'
> Rep partno
> Go
There is a partno in the database P03, that should be reported. But I
get zero records found.
I tried this code, and get an error message:
> access partmaster
> choose partno "@"
^^^
*E* The generic choose character is not allowed without a prefix.
>
So is the manual wrong? I'm I interpreting the manual wrong? I'm
confused.