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
- :
- SQL Scripts will not run in small update
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
‎Feb 25, 2009
03:51 PM
SQL Scripts will not run in small update
I've created a small update from our last install and have some sql scripts that need to be run when the update is applied. However, when I add the new script that needs to be run nothing happens. From what I can tell in the log, the script is not scheduled to be run but I'm not sure how to force it to run. I have not set any conditions on this script for now and the run on install check box is checked. The timeout on the connection is zero. This was originally a basic msi project if that makes any difference.
This is what I see in the log:
1: Processing the SQL connection 'DBSqlConnection'...
1: Determining if there is at least one SQL script scheduled to execute under the connection...
1: The SQL script 'PatchScript.sql' is not scheduled to execute. Script Execution=RunOnInstall, Action=Install, Component State=None, Schema=
Any help would be greatly appreciated. Also, could someone point me to a more thorough form of documentation for installshield because the help file is rarely useful for some of the more difficult things that pop up (like this problem).
This is what I see in the log:
1: Processing the SQL connection 'DBSqlConnection'...
1: Determining if there is at least one SQL script scheduled to execute under the connection...
1: The SQL script 'PatchScript.sql' is not scheduled to execute. Script Execution=RunOnInstall, Action=Install, Component State=None, Schema=
Any help would be greatly appreciated. Also, could someone point me to a more thorough form of documentation for installshield because the help file is rarely useful for some of the more difficult things that pop up (like this problem).
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 27, 2009
11:55 AM
Nobody has any ideas? I'm sure it's just something small I'm not doing but I can't seem to figure out what.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 02, 2009
12:41 PM
The SQL scripts are explicitly tied to component states. In your Windows Installer verbose log file, you may be able to find some more information as to why the component associated with the 'PatchScript.sql' thinks it does not need to reinstall.
![](/skins/images/3B39CE851FDD5528C393F146EB70A2D0/responsive_peak/images/icon_anonymous_message.png)