Regarding SQL Scripts,
It would be nice to have an option in the "In case of error" section for "Continue Anyway"...
If for example I expect an error or two to occur in the script under certain conditions but the errors are inconsequential, the entire script should still execute to completion.
"Go to the next statement in the script file" is not working properly for me because I have no statement seperator so defining a semi-colon as the statement seperator in AdvancedInstaller is not working. Selecting this option just yeilds error after error of broken SQL statements and I have no other option available to continue executing the script...
The nature of transact-sql is for an entire transaction to fail anyway so you should never need to go to the next statement in a script file... it should go to the next transaction (e.g. the end of the failed transaction, often specified as "GO" in syntax).
Thanks,
GS
FOLLOW US
Get the latest news in Application Packaging