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
Use a SQL parameter from a list (Read 3276 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Use a SQL parameter from a list
08.01.08 at 21:55:36
 
Use a SQL parameter from a list
 
I want to test, how I can use the content of one Excel-cell as a
parameter for a SQL-Request to Oracle. The User can select one topic
of a list, and this will be the parameter. Is this possible? Is on
your website anywhere an info for the syntax?  
 
Answer:
Yes you can. You can use a cell as parameter in a few ways. Suppose your parameter is a number and it is stored in A1.
 
You can execute: select * from mytable where mycol = :A1;
 
You can also build the SQL on the sheet using the Excel concatenate function. Just build the SQL on the sheet. Select it and open the SQL window. SQL*XL will switch to the mode to use the selected SQL on the worksheet.
 
There are other options too. See:
http://www.oraxcel.com/projects/sqlxl/help/techniques/parameters.html  
http://www.oraxcel.com/projects/sqlxl/help/commands/define.html  
http://www.oraxcel.com/projects/sqlxl/help/commands/accept.html  
http://www.oraxcel.com/projects/sqlxl/help/dialogs/parameters/index.html  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1149170343
Back to top
 
« Last Edit: 08.01.08 at 22:00:23 by Gerrit-Jan Linker »  

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