RE: Passing parms to query

Hey, I'm glad I'm not the only one.  I couldn't figure out how to give a
character variable a value.  Of course, as soon as I sent a message to the
list, it worked fine.  Oh well, I guess I really do belong in the slow
group.

Thanks, everyone, for the help.

At the risk of looking dumb (again), when I run STRQMQRY against a query
definition, I don't get any of the query's formatting.  (Column headings,
summary functions, report breaks, etc. are ignored).  Am I doing something
wrong (which I've been known to do on occasion), or is the query definition
always ignored by STRQMQRY?

Bob L.

> -----Original Message-----
> From: Roger Boucher [SMTP:RBoucher@stanpac.com]
> Sent: Wednesday, December 30, 1998 11:25 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Passing parms to query
> 
> If everyone would please disregard this question... it works today, even
> though it didn't work the other day!  Must have been some sort of EBCAK
> I guess.
> 
> Thanks again!
> 
> -----Original Message-----
> From: Pete Hall [mailto:peteh@inwave.com]
> Sent: Tuesday, December 29, 1998 7:49 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Passing parms to query
> 
> 
> At 14:34 12/28/1998 -0800, Roger Boucher wrote:
> >So... I didn't know you could do this!  I've been trying it...
> selecting
> >on a field with a selection value of :field and it works great as long
> >as the field is alpha.  But if the field I'm selecting on is numeric...
> >no luck.  It runs but doesn't select the record.  I've tried creating a
> >QMQRY just to make sure and that works fine.  Anyone got any ideas?
> >Thanks in advance!
> 
> A numeric literal in STRQMQRY must be passed in a character variable,
> and
> must NOT be enclosed in apostrophes.
> 
> hth
> 
> Pete Hall
> peteh@inwave.com
> http://www.inwave.com/~peteh
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---