Can metacharacters be used in a select prompt?

Fri, 28 Feb 2003 09:38:14 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2DF37.063A13E0
Content-Type: text/plain;
	charset="iso-8859-1"

You can find documentation in the Qdesign manual, Customizing QUICK with
QKGO (in 8.xx manuals it is chapter 6) The Data Commands Screen, under the
pattern match character.

-----Original Message-----
From: Tim Cummings [mailto:tim.cummings@frequencymarketing.com]
Sent: Friday, February 28, 2003 8:52 AM
To: 'Peter Bateman'; chris.sharman@ccagroup.co.uk; Tim Cummings;
powerh-l@lists.swau.edu
Subject: RE: Can metacharacters be used in a select prompt?

Hey Chris, 

Is the "%" for select prompts documented anywhere?  I was looking through
the manual and found all of the metacharacter descriptions, but I saw
nothing on "%" in select prompts 

Tim Cummings 
Cummings Consulting 
Cincinnati, OH 
513-576-1182 

-----Original Message----- 
From: Peter Bateman [ mailto:shediac92@hotmail.com
<mailto:shediac92@hotmail.com> ] 
Sent: Friday, February 28, 2003 7:25 AM 
To: chris.sharman@ccagroup.co.uk; tim.cummings@frequencymarketing.com;
powerh-l@lists.swau.edu 
Subject: RE: Can metacharacters be used in a select prompt? 

Chris: 

To put metacharacters in a prompt, I would put the characters 
in a define ... parm prompt. 

ie DEFINE match_string char * 30 = parm prompt "Enter selection" 

ACCESS ... 
SELECT IF " " = match_string & 
        OR MATCHPATTERN ( (NAME + ADDRESS), TRUNCATE (match_string)) 

>From: "Chris Sharman" <chris.sharman@ccagroup.co.uk> 
>To: "Tim Cummings" <tim.cummings@frequencymarketing.com>,  
><powerh-l@lists.swau.edu> 
>Subject: RE: Can metacharacters be used in a select prompt? 
>Date: Fri, 28 Feb 2003 08:41:08 -0000 
> 
> 
> >Quick question:  HP3000 PH 8.1.9 C2 
> > 
> >I know that you can use something like bell@ in a field when supplying 
>select >values in select mode, but is there a way to supply metacharacter 
>patterns?  I >know I can write the code to make this work but I don't want 
>to write code.  I >want to use native PH to do the work. 
> 
>Yes. 
> 
>The user should enter % to say treat this expression as a pattern. 
> 
>eg "%^(#|^)* *" for an identifier (alpha optionally followed by 
>alphanumerics, with space padding to the end of the field). 
> 
>On a similar line, does anyone know how to have metacharacters treated 
>normally when entering a choose parm ? 
>Eg, we have email addresses keyed, but the find doesn't work, because the 
>"@" always gets treated specially (PH 710G3, VMS 7.3). I'd thought it was 
>only special at the end of an expression, but that doesn't seem to be the 
>case. In fact I don't know what it means in the middle of an expression, 
>but 
>it finds precious little. 
> 
>Chris 
> 
> 
>----------------------------------------------------------------------- 
> 
>Any views expressed in this message are those of the sender and not 
>necessarily those of CCA Group.  The unauthorized use, disclosure, 
>copying or alteration of this message is forbidden 
>this message may be confidential and/or privileged, copyright CCA Group 
>and are intended solely for the use of the individual or entity to whom 
>they are addressed.  Whilst this message has been scanned, CCA Group 
>cannot guarantee that it is virus free or compatible with your systems 
>and accepts no responsibility for any loss or damage arising from its 
>use. The recipient is advised to run their own anti-virus software. If 
>you receive this message in error please contact 
>postmaster@ccagroup.co.uk immediately, destroy any copies and delete it 
>from your computer systems. 
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
>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
<http://lists.swau.edu/mailman/listinfo/powerh-l>  
>This list is closed, thus to post to the list you must be a subscriber. 

_________________________________________________________________ 
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail
<http://join.msn.com/?page=features/junkmail>  

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C2DF37.063A13E0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Can metacharacters be used in a select prompt?</TITLE>

<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY>
<DIV>You 
can find documentation in the Qdesign manual, Customizing QUICK with QKGO (in 
8.xx manuals it is chapter 6) The Data Commands Screen, under the pattern match 
character.</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Tim Cummings 
 [mailto:tim.cummings@frequencymarketing.com] Sent: Friday, February 
 28, 2003 8:52 AM To: 'Peter Bateman'; chris.sharman@ccagroup.co.uk; 
 Tim Cummings; powerh-l@lists.swau.edu Subject: RE: Can 
 metacharacters be used in a select prompt? </DIV>
 Hey Chris, 
 Is the "%" for select prompts documented anywhere?&nbsp; I was 
 looking through the manual and found all of the metacharacter descriptions, 
 but I saw nothing on "%" in select prompts 
 Tim Cummings Cummings 
 Consulting Cincinnati, OH 513-576-1182 
 -----Original Message----- From: Peter 
 Bateman [<A 
 href="mailto:shediac92@hotmail.com">mailto:shediac92@hotmail.com</A>] 
 Sent: Friday, February 28, 2003 7:25 AM To: chris.sharman@ccagroup.co.uk; tim.cummings@frequencymarketing.com; 
 powerh-l@lists.swau.edu Subject: RE: Can 
 metacharacters be used in a select prompt? 
 Chris: 
 To put metacharacters in a prompt, I would put the 
 characters in a define ... parm prompt. 
 ie DEFINE match_string char * 30 = parm prompt "Enter 
 selection" 
 ACCESS ... SELECT IF " " = 
 match_string &amp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR MATCHPATTERN ( (NAME + 
 ADDRESS), TRUNCATE (match_string)) 
 &gt;From: "Chris Sharman" 
 &lt;chris.sharman@ccagroup.co.uk&gt; &gt;To: "Tim 
 Cummings" &lt;tim.cummings@frequencymarketing.com&gt;,&nbsp; &gt;&lt;powerh-l@lists.swau.edu&gt; &gt;Subject: RE: Can metacharacters be used in a select prompt? 
 &gt;Date: Fri, 28 Feb 2003 08:41:08 -0000 &gt; &gt; &gt; 
 &gt;Quick question:&nbsp; HP3000 PH 8.1.9 C2 &gt; 
 &gt; &gt; &gt;I know that you can use something like 
 bell@ in a field when supplying &gt;select &gt;values 
 in select mode, but is there a way to supply metacharacter &gt;patterns?&nbsp; I &gt;know I can write the code to make this work 
 but I don't want &gt;to write code.&nbsp; I &gt;want 
 to use native PH to do the work. &gt; &gt;Yes. &gt; &gt;The 
 user should enter % to say treat this expression as a pattern. 
 &gt; &gt;eg "%^(#|^)* *" for an 
 identifier (alpha optionally followed by &gt;alphanumerics, with space padding to the end of the field). 
 &gt; &gt;On a similar line, does 
 anyone know how to have metacharacters treated &gt;normally when entering a choose parm ? &gt;Eg, we have email addresses keyed, but the find doesn't work, 
 because the &gt;"@" always gets treated specially (PH 
 710G3, VMS 7.3). I'd thought it was &gt;only special 
 at the end of an expression, but that doesn't seem to be the &gt;case. In fact I don't know what it means in the middle of an 
 expression, &gt;but &gt;it 
 finds precious little. &gt; &gt;Chris &gt; &gt; &gt;----------------------------------------------------------------------- 
 &gt; &gt;Any views expressed in this 
 message are those of the sender and not &gt;necessarily those of CCA Group.&nbsp; The unauthorized use, 
 disclosure, &gt;copying or alteration of this message 
 is forbidden &gt;this message may be confidential and/or 
 privileged, copyright CCA Group &gt;and are intended 
 solely for the use of the individual or entity to whom &gt;they are addressed.&nbsp; Whilst this message has been scanned, CCA 
 Group &gt;cannot guarantee that it is virus free or 
 compatible with your systems &gt;and accepts no 
 responsibility for any loss or damage arising from its &gt;use. The recipient is advised to run their own anti-virus software. 
 If &gt;you receive this message in error please 
 contact &gt;postmaster@ccagroup.co.uk immediately, 
 destroy any copies and delete it &gt;from your 
 computer systems. &gt;= = = = = = = = = = = = = = = = 
 = = = = = = = = = = = = &gt;Mailing list: 
 powerh-l@lists.swau.edu &gt;Subscribe: "subscribe" in 
 message body to powerh-l-request@lists.swau.edu &gt;Unsubscribe: "unsubscribe" in message body to &gt;powerh-l-request@lists.swau.edu &gt;<A 
 target=_blank 
 href="http://lists.swau.edu/mailman/listinfo/powerh-l">http://lists.swau.edu/mailman/listinfo/powerh-l</A> 
 &gt;This list is closed, thus to post to the list you must be 
 a subscriber. 
 _________________________________________________________________ 
 STOP MORE SPAM with the new MSN 8 and get 2 months 
 FREE*&nbsp; <A target=_blank 
 href="http://join.msn.com/?page=features/junkmail">http://join.msn.com/?page=features/junkmail</A> 
 </BLOCKQUOTE></BODY></HTML>

This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.

------_=_NextPart_001_01C2DF37.063A13E0--