This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: "Run Script During Login" ignore conditions.
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 17, 2007
03:12 AM
"Run Script During Login" ignore conditions.
My installer should allow installation of multiple databases.
To do this i created new connection in "SQL Scripts" category with two script files.
"Run Script During Login" checked for both..
As i understand this means that ISSQLServerValidate action will run scripts.
But i want only one script to execute accordingly to type of db, so i specified conditions for each script. But installer ignore them, and both scripts executes.
When "Run Script During Install" checkbox checked, all ok. Scripts executed accordingly to conditions.
Can anybody explain this?
Also i found IS_SQLSERVER_CXNS_ABSENT_FROM_INSTALL property:
"Specifies one or more SQL connections that should be skipped during installation or uninstallation. To specify more than one SQL connection, separate each with a semicolon (;). To skip all of the SQL connections, set the value of this property to ALL. Using this property is helpful if you cannot uninstall a product because of a SQL scripting error. "
But this property also doesn't work with "Run Script During Login" option :(((
To do this i created new connection in "SQL Scripts" category with two script files.
"Run Script During Login" checked for both..
As i understand this means that ISSQLServerValidate action will run scripts.
But i want only one script to execute accordingly to type of db, so i specified conditions for each script. But installer ignore them, and both scripts executes.
When "Run Script During Install" checkbox checked, all ok. Scripts executed accordingly to conditions.
Can anybody explain this?
Also i found IS_SQLSERVER_CXNS_ABSENT_FROM_INSTALL property:
"Specifies one or more SQL connections that should be skipped during installation or uninstallation. To specify more than one SQL connection, separate each with a semicolon (;). To skip all of the SQL connections, set the value of this property to ALL. Using this property is helpful if you cannot uninstall a product because of a SQL scripting error. "
But this property also doesn't work with "Run Script During Login" option :(((
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 24, 2007
04:40 PM
I worked with Marachkovski offline and solved the issue. The SQL Scripts are explicitly tied to component states, and the condition that you are setting in the SQL view is actually the condition on the underlying component. Therefore, the condition only works for SQL scripts that run during install. The solution was to coditionally run the SQL scripts using a RAISERROR T-SQL statement and Custom Error Handling functionality.