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: SQL Script conditional on Setup Type?
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
‎Jan 21, 2009
11:17 AM
SQL Script conditional on Setup Type?
I have an InstallScript MSI project with 3 SQL Scripts that only need to run for specific Setup Types. I have been trying to set the condition on the Runtime tab, but so far I've only been able to either have the scripts run all the time or none of the time.
One thing I tried is basing it on a feature that is only installed when I want those scripts to run, so I used: &MyFeature = 3 That just made the scripts never run at all.
In the actual InstallScript I have a global variable that I set for the SetupType, but using that variable doesn't seem to affect the conditions at all.
What am I missing here?
One thing I tried is basing it on a feature that is only installed when I want those scripts to run, so I used: &MyFeature = 3 That just made the scripts never run at all.
In the actual InstallScript I have a global variable that I set for the SetupType, but using that variable doesn't seem to affect the conditions at all.
What am I missing here?
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2009
12:18 PM
Do you associate the underlying components of your SQL scripts with the MyFeature feature? If not, please try that and remove the condition from your SQL scripts.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2009
04:05 PM
How did I miss that? 😄
That seems to have worked well for 2 out of my 4 scripts, but the other 2 almost seem to be acting as if the condition is still present. I've checked the table and do not see them there or in the Runtime tab. Would it be prudent to just recreate those scripts from scratch?
That seems to have worked well for 2 out of my 4 scripts, but the other 2 almost seem to be acting as if the condition is still present. I've checked the table and do not see them there or in the Runtime tab. Would it be prudent to just recreate those scripts from scratch?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2009
04:09 PM
I would recommend you to generate a Windows Installer verbose log for the installation, and see why those scripts in question are not getting installed as expected.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 22, 2009
12:52 PM
The verbose log didn't really show me anything amiss, but after deleting the sql scripts from the project, saving, and then adding them back in, everything seems to be working great now.
Thanks hidenori!
Thanks hidenori!