Linker IT Software
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 3435 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:
Can you only rerun a query when the SQL is stored in a comment?
No, but it is the most common technique to do this. See for details:
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:
Start command:
SQL Favorites:
Back to top

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