Passing a parameter to a SQL statement using a variable

Interactive · **Posted:** April 7th, 2010, 9:13 pm

Does anyone know how to pass a parameter to a SQL statement (ex: SELECT * FROM Tabela WHERE Field=<variable>)?

Lar_123 · **Posted:** April 7th, 2010, 11:23 pm

Quote:

how to pass a parameter to a SQL statement (ex: SELECT * FROM Tabela WHERE Field=<variable>)?

Do you mean this:

Code:

SELECT * FROM Tabela04 WHERE Field002= '"+variable014+"' ;

Going a little further, you can write your SQL Statement into a variable and then just reference that variable later where the SQL Statement is expected. Just be sure to use surrounding quote marks and include the ending semi-colon.

Code:

var getCustomerSQL = "SELECT CustomerName FROM CustTable WHERE RegionCode = '"+variable014+"' ;"

//later, calling the function ListCustomers() --- which will use the SQL Statement
ListCustomers(getCustomerSQL)

Interactive · **Posted:** April 8th, 2010, 1:50 am

Thank you very much for your help, my friend. It worked fine!

Interactive · **Posted:** April 8th, 2010, 2:59 pm

Dear Lar_123,

In completion to my question, let me ask your attention again:
where is the statement below syntatically wrong?

"INSERT INTO Table1 (Field1,Field2) VALUES ('" + variable1 + "', '" + variable2 + "');"

I would really appreciate your attention.
Thanks in advance!

Lar_123 · **Posted:** April 8th, 2010, 7:38 pm

Int,

I don't know. I'll have to look into it.
My first impression and guess is to try this:

Code:

"INSERT INTO Table1 (Field1,Field2) VALUES ( variable1, variable2 );"

In the meantime you could do a little browsing here in the forum, simply search for SQL and SELECT keywords, or SQL and INSERT keywords. You will find some examples of opusscript that confirm variable names are written directly into certain parts of the sql statement.

Digital Workshop

Passing a parameter to a SQL statement using a variable

Who is online