Re: QM Question

["Bill" <brobins3d@xxxxxxxxx>]

Dennis,

If I remember correctly, you -could- make all or part of the Where statement the
variable.  In other words treat it like some people treat the QrySlt parameter
of the OpnQryF command; build the relevant parts of the statement in a CL
variable and then substitute it.

Select * from myfile Where field1 = &wherestmt

In your CL you load variable &wherestmt with the comparison to field1 and then
you formulate the rest of the statement only if the user did not select *all as
the selection criteria.  Remember to double up the quotes for any alpha
comparisons because StrQMQry will strip out one set of them when passing the
variable on.

Bill


----- Original Message -----
> query.  What has me struggling now is how do I pass in a variable from the
> display file that contains *ALL to the query.  One thought was to do a



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---