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
Rerunning a SQL favorite (Read 3962 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Rerunning a SQL favorite
25.02.07 at 12:38:59
 
Rerunning a SQL favorite
 
Question:
I have a query that is a favorite and I am re-running it and the old data remains there and it will overwrite the cells but it does not clear out the entire sheet so it can load it fresh. I have to first clear the contents of the sheet and then run it. Am I a doing something wrong or is this not a feature.
 
Answer:
The blanking of old data only occurs when you rerun a query using the refresh queries button. When you run a query as a SQL favorite the blanking will not be done. You are expected to chose a location where the data should go although you can hard code that into the query using the To clause (see: http://www.oraxcel.com/projects/sqlxl/help/commands/selectto.html).
 
You can however use the clear screen command (see: http://www.oraxcel.com/projects/sqlxl/help/commands/clear.html). This will clear the current worksheet.
 
If required I could make a clear statement that takes a cell range to clear. E.g. clear A3Cheesy12;
Back to top
 
« Last Edit: 15.03.10 at 10:49:18 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Rerunning a SQL favorite
Reply #1 - 02.03.07 at 11:06:26
 
I have expanded the clear command so you can use the clear command to clear out a specific range of cells. Just type it into the SQL dialog or into the SQL favorite as extra command. The syntax is:
 
clear excel_range_address;
 
This new syntax is available in SQL*XL 4.1.12 or higher.
 
Examples:
 
clear A1;
clear A10:D30;
clear sheet1!A:Z;
 
For further details, see
http://www.oraxcel.com/projects/sqlxl/help/commands/clear.html
Back to top
 
« Last Edit: 02.03.07 at 11:08:12 by Gerrit-Jan Linker »  

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