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
Error handling (Read 3256 times)
fred
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Error handling
24.05.06 at 20:32:35
 
Just ran accross an interesting case that would have been resolved if the orcle error could be displayed, when generated.
 
Queried a table that the user was not granted selected on, which generated a "system" error. The oracle error is "Table does not exist" which would be more meaningful....
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Error handling
Reply #1 - 24.05.06 at 23:32:52
 
SQL*XL does not block the system errors.
 
If an expected error is returned sometimes SQL*XL applies a workaround or a more meaningful advice message.  
If the error is truely unexpected it is displayed through the error handlers and it is offered to send the error in for analysis to us.
 
If you have a scenario that does not adhere to the above scenarios please let me know what the precise scenario is so I can investigate. I need the driver, database type and the scenario that led to the error.
 
The intention of the implementation in SQL*XL is to not bother the user when a workaround is known, to notify the user with a helpful message it is a known problem and to offer to send the technical details to us for analysis if there was an unknown error.
Back to top
 
 

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