|
Use apostrophes (') instead of quotes (") around your variable value. A quoted string is interpreted to be a column name. A character literal must be enclosed in apostrophes. PS This is helpful when you have a column name that is also an SQL reserved word. For example, if you had a column named GROUP, SQL would complain about this: select group from table1 thinking that the word group was starting a group-by clause. Quoting the column name solves the problem: select "GROUP" from table 1 Please respond to MIDRANGE-L@midrange.com To: IDRANGE-L@midrange.com> cc: (bcc: Brian Johnson/HelpSystems) Subject: RE: Passing Parameters to Query OK, I guess I belong in the slow group. 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 Message type . . . . . : Diagnostic Date sent . . . . . . : 12/28/98 Time sent . . . . . . : 15:44:07 Message . . . . : Column ABC not in specified tables. +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.