RE: Passing Parameters to Query

[Buck Calabro/commsoft<mcalabro@xxxxxxxxxxxx>]

>I set up a query with the following record selection:
>
>  FGNAME            EQ     :item 
>
>where FGNAME is an alpha field in the file I'm querying. 
>I then interactively ran the STRQMQRY command against 
>the saved query definition.
>I got the following prompt:
>
>  Type a value for variable "ITEM" and press Enter.
>
>I then entered "ABC" and pressed Enter.  I got the following error:
>
>Message ID . . . . . . :   SQL0206       Severity . . . . . . . :   30

-snip-

>This leads me to believe that the value I enter for 
>":item" represents the field I want to compare FGNAME 
>to, rather than the actual value I want to compare 
>FGNAME to.

Use tick marks around the value ABC.  That's how the 
SQL interpreter knows the difference between a column 
name and a literal value, i.e.

where fgname = ABC       vs
where fgname = 'ABC'

hth,
Buck Calabro
CommSoft, Albany, NY
mailto:mcalabro@commsoft.net




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