Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Variables in function SQLQueryValue (Read 2065 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Variables in function SQLQueryValue
07.04.08 at 21:20:38
 
Variables in function SQLQueryValue
 
Question:
I try to insert function
SQLQueryValue in cells as well, but during opening the workbook the
alert appered -  no oracle variables bound.
 
Answer:
Bind variables should not be used in the SQLQueryValue function. They should be embedded into the SQL. Examples:
 
=SQLQueryValue(concatenate("select * from mytable where col = " , A1))
 
Let me know if you need some help formatting the variables into text to include into the statement.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1