Pattern Help

[Lorry Litman]

Hi,

The problem I believe you're going to have with trying to exclude M,C,# as
the first character is that the PATTERN function does not have and AND
option (which is what you need)it only has an OR option.
If your field statement is anything like
FIELD TEMP PATTERN = "(\M|\C|\#)#####"
as soon as you put the | you've negated what you're trying to accomplish,
because M fails \M but passes \C and also passes \#, and so on.

Since you mention you're useing Quick my suggestion would be
FIELD TEMP PATTERN "^#####"
PROCEDURE INPUT TEMP
BEGIN
IF 0 < SIZE(FIELDTEXT) AND MATCHPATTERN(FIELDTEXT[1:1],"M|C"
THEN .....
END

There are other variations on the same theme, putting more in the input
procedure, taking off the pattern statement from the field statement
completely...

Hope this helps

Thanx
    Lorry

-----Original Message-----
From: Sarah Moore [mailto:MOORSAR@co-opsonline.com]
Sent: Thursday, November 29, 2001 12:07 PM
To: powerh-l@lists.swau.edu
Subject: Pattern Help


We are using Powerhouse 6.20 on OpenVMS.

We had this original pattern on a field in QUICK "^#####" 

We want to restrict it to not let the Alpha be equal to M or C. We tried a
lot
of different combinations and found this one. "\M#####" which restricted
the M but allows the user to enter 6 digits. Also, we were not able to
restrict the C. 

Thanks in advance

Sarah Moore 
Co-op Atlantic
Moncton, NB

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" 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.