If using code that potentially can fail from time to time it is possible to use a Try Catch-statement and programmatically handle the error as opposed to having the application error out. Syntax for Try/Catch statement: Try // Commands to try to execute End Try Catch // Commands to execute when an error occurs End Catch
Example:
TRY // Try the commands between this line and End Try IMPORT [budget]=excelfile.{select * from [c:\budget\custombudgetfile.xlsx]} // Import budget from file that may be edited by people in the organizationEND TRYCATCH // If the try fails the commands in this catch block will be executed PRINT 'An error occurred loading the custom budget file - will default to loading the audited budget file' IMPORT [budget]=excelfile.{select * from [c:\budget\auditedbudgetfile.xlsx]} // Load the budget file that we knowEND CATCH
Overview
Content Tools