Handling SQL Run-Time Errors
                                                InstallShield 2025
                                                
                                                Project:
                                                    This information applies to the following project types:
                                                
                                                
                                                
                                                
                                                To set SQL script error-handling properties in the interface:
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | 1. | In the View List under Server Configuration, click SQL Scripts. | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | 2. | In the SQL Scripts explorer, click the SQL script file for which you want to add error handling. | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | 3. | Click the Runtime tab. | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | 4. | In the Script Error Handling area, select one of the options listed, or click the Custom button to override the script’s default error handling. Available options are: | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | • | On Error, Goto Next Script | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | • | On Error, Goto Next Statement | 
                                                
                                                
                                                    
                                                    
                                                    
                                                    
                                                        |  | • | On Error, Abort Installation | 
                                                
                                                See Also
                                                SQL Scripts View