User Input Field to be used in Where Clause of SQL script?

Wed, 08 May 2013 22:06:20 GMT

I have read many discussions on User Input prompts.

I am looking to load data from a SQL script

and I need the where clause to load from the value of what the user typed in the User Input Prompt.

Here's what I have so far; but I get an error message:

LET vMyVar = INPUT('Enter Incident #', 'Input box');

SQL SELECT *

FROM ( SELECT "INCIDENT_NUMBER"

FROM AUDITED_FIELDS

WHERE "INCIDENT_NUMBER" = mMyVar);

any help?

I am getting the following error:

ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "VMYVAR": invalid identifier

Re: User Input Field to be used in Where Clause of SQL script?

Wed, 08 May 2013 23:41:52 GMT

I figured it out.

Needed to state Where "INCIDENT_NUMBER" = $(mMyVar);

and it worked!!