Skip to content

SqlString Element (Sql Extension)

Description
SQL String
Windows Installer references
None
Parents
Component, SqlDatabase
Inner Text
None
Children
None
Attributes
Name Type Description Required
Id String   Yes
ContinueOnError YesNoType Continue executing strings even if this one fails.  
ExecuteOnInstall YesNoType Specifies to execute the string when the associated component is installed. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes.  
ExecuteOnReinstall YesNoType Specifies whether to execute the string when the associated component is reinstalled. Setting ExecuteOnInstall to yes does not imply ExecuteOnReinstall is set to yes. ExecuteOnReinstall must be set in addition to ExecuteOnInstall for it to be executed during both install and reinstall. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes.  
ExecuteOnUninstall YesNoType Specifies to execute the string when the associated component is uninstalled. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes.  
RollbackOnInstall YesNoType Specifies whether to execute the string on rollback if an attempt is made to install the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes.  
RollbackOnReinstall YesNoType Specifies whether to execute the string on rollback if an attempt is made to reinstall the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes.  
RollbackOnUninstall YesNoType Specifies whether to execute the string on rollback if an attempt is made to uninstall the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes.  
Sequence Integer Specifes the order to run the SQL Strings. It is recommended that rollback strings be scheduled before their complementary execution string. This order is also relative across the SqlScript element.  
SQL String   Yes
SqlDb String    
User String    
See Also
Sql Schema