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
change SQL statement in Spreadsheet (Read 3661 times)
hziegler
YaBB Newbies
*




Posts: 1
change SQL statement in Spreadsheet
17.10.05 at 10:46:53
 
I try to change the SQL statement in my excel sheet and rerun the query, but after the run the old SQL statement is shown.
(Put SQL in note) already done. Any ideas how i can handle this? Thanks!
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: change SQL statement in Spreadsheet
Reply #1 - 17.10.05 at 11:04:26
 
SQL*XL picks up the SQL in the following way:
 
When you start the SQL dialog and you have a cell selected with a comment that contains the SQL from a previous run, SQL*XL will take that SQL to use.
 
When you start the SQL dialog and you have selected a cell without a comment it will show the previous statement you have executed.
 
When you start the SQL*XL dialog and when you have selected more than one cell, the SQL will be taken from the contents in the cells.
 
In your case you had probably not selected the cell with the comment in which you edited the SQL. SQL*XL then opened the SQL dialog showing the previous SQL, the one that you had just modified in the note.
 
Hope this helps.
Back to top
 
 

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