Re: Passing parameters to a query

[Pete Hall <peteh@xxxxxxxxxx>]

I screwed up ...
>At 08:01 AM 6/11/98 -0400, Damian Esealuka wrote: 
>>
>> Can someone show me or direct me on how to run a query through a CL that will
>> prompt the user to enter values(selection) and use the entered values to
>> complete the query.
>> Thanks
>>  

Part of my response was:

>query management query. You can execute this with STRQMQRY, which allows you to
>pass parameters in from CL. If a parameter is numeric, just pass the variable.

This is incorrect. If the field is numeric, you don't enclose it in tic marks 
as you must do with an alpha field, but you must pass the value in an alpha 
variable. You would need to declare a character variable with the same length 
as the zoned representation of the numeric variable, execute CHGVAR to move the 
value to the alpha variable and pass that to the QMQRY.

Pete


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
+---