SQL Runtime Error trapping - Violation of PRIMARY KEY constraint 'ABC'. Cannot insert duplicate key in object 'dbo.XZY'. The duplicate key value is (-508)

Yes

Summary

Discussion about options using SQL script view and runtime error trapping

Synopsis

There is no native support to trap and then prompt that an error at runtime caused by a SQL script has occurred. For example, if you include a SQL script that errors during runtime there are some options to use in an effort to handle the error case. However, you cannot prompt the user that some error has occurred natively.

Discussion

If your script exposes an error at runtime you have options set in the project to Goto Next Script, Goto Next Statement, Abort the Installation or define an override for the scripts default error handling. The last option is achieved when you select 'Custom' and manually set the error handling. Error handling settings are set on the tab 'Runtime' in the IDE.

When using 'Custom' you can trap the error and set the specific behavior based on the three mentioned above. For example, to you trap for Violation of PRIMARY KEY constraint you set in the project On Error Abort the Installation, Goto Next Script or Goto Next Statement.

There is a debugging option pre-build. The InstallShield product includes support when/if you have Microsoft SQL Server Management Studio or Microsoft SQL Server 2000 SQL Query Analyzer installed on your system, you can open a new SQL script that you have added to your project to test, edit, and syntax-check the script. To launch one of those tools and open your script from within InstallShield, right-click the script file in the SQL Scripts view and then click Open Script in Microsoft SQL Server Management Studio. InstallShield searches for one of the following tools and launches the first one that it finds:

? Microsoft SQL Server 2008 Management Studio (any edition, including Express; ssms.exe)

? Microsoft SQL Server 2005 Management Studio (SqlWb.exe)

? Microsoft SQL Server 2005 Management Studio Express (ssmsee.exe)

? Microsoft SQL Server 2000 Query Analyzer (isqlw.exe)

SQL Runtime Error trapping - Violation of PRIMARY KEY constraint 'ABC'. Cannot insert duplicate key in object 'dbo.XZY'. The duplicate key value is (-508)