Wild Card/Generic retrieval

[Edis, Robert]

Dianne

I believe that when you use the syntax indicated you can't use an '@' as the first character of the value.  The manual reference you mention would work with the MATCHPATTERN function.

I don't remember if you can use this function in the CHOOSE statement in Quiz.  Why not try SELECT IF MATCHPATTERN (partno, "@03")?

Blue

-----Original Message-----
From: Landers, Dianne [mailto:DLanders@pcc-structurals.com]
Sent: Tuesday, September 09, 2003 12:12 PM
To: powerh-l@lists.swau.edu
Subject: Wild Card/Generic retrieval


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.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.