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
How to rerun a query? (Read 2721 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
How to rerun a query?
25.10.05 at 17:41:52
 
A customer asked the following question today:
 
Question:
Can you only rerun a query when the SQL is stored in a comment?
 
Answer:
No, but it is the most common technique to do this. See for details:
http://www.oraxcel.com/projects/sqlxl/help/techniques/rerun.htm
 
You can also use the SQL Favorites and the select to command to achieve it. Write a select statement including the to clause. Then save it as a SQL Favorite. Selecting the favorite will reexecute the query and you have preset the results location so it will overwrite previous results.
 
You can also make use of the macro recording facility. Just record the whole session as a macro. Rerunning the macro is essentially refreshing the data.
 
A few references:
 
Select to command:
http://www.oraxcel.com/projects/sqlxl/help/commands/selectto.html
 
Start command:
http://www.oraxcel.com/projects/sqlxl/help/commands/start.html
 
SQL Favorites:
http://www.oraxcel.com/projects/sqlxl/help/menu%20items/favorites.html
Back to top
 
 

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