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: Manually Executing SQL scripts
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 12, 2009
11:49 AM
Manually Executing SQL scripts
Hello, I have an InstallScript/MSI project in which I would like to manually control the execution of SQL scripts by using the LaunchApplication function rather than listing the SQL scripts I want to execute in the SQL scripts view. Does anybody know if this can be done? If so, how would you do it? I have written an InstallScript Custom Action to do this, but it seems that Custom Action never gets executed regardless of where I put it in either the install UI or install Execute sequence.
Any advice would be appreciated!
Tim
Any advice would be appreciated!
Tim
(7) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 12, 2009
02:34 PM
If it's an InstallScript MSI project, can you put your code in one of the events, instead of using an InstallScript custom action?
Otherwise, if you create an MSI log file during deployment, is your action being called (or is the reason it's not being called listed)?
Otherwise, if you create an MSI log file during deployment, is your action being called (or is the reason it's not being called listed)?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 12, 2009
02:46 PM
Thanks for the reply Robert. By one of the events do you mean one of the InstallScript events like OnMoving or OnMoved?
Thanks!
Tim
Thanks!
Tim
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 12, 2009
02:53 PM
Tim,
Yes, those are the events I mean; you can see them in those drop-down lists in the InstallScript view, and the documentation (and in-script comments) should have details about any specific ones you're interested in.
Good luck,
Robert
Yes, those are the events I mean; you can see them in those drop-down lists in the InstallScript view, and the documentation (and in-script comments) should have details about any specific ones you're interested in.
Good luck,
Robert
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 12, 2009
03:58 PM
Thanks Robert, I will give it a shot.
Tim
Tim
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 12, 2009
10:13 PM
That worked Robert. Now, I have two different issues I could use some help with. 1. The text displayed on the dialog while the SQL scripts are executing says "calculating disk space" or something like that. I would like to update that text to say something like "Executing SQL scripts". I tried using the SetStatusExStaticText function but the text appeared at the top of the dialog box, and did not overwrite the existing displayed message.
2. At the end of the install, a dialog informing the end-user that the installation was successful and prompting them to restart the computer appears eventhough I have set the REBOOT property to ReallySuppress. I am not sure why this is happening.
Thanks in advance!
Tim
2. At the end of the install, a dialog informing the end-user that the installation was successful and prompting them to restart the computer appears eventhough I have set the REBOOT property to ReallySuppress. I am not sure why this is happening.
Thanks in advance!
Tim
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 13, 2009
08:53 AM
Take a look at SdShowMsg.
SdShowMsg("Show my message...", TRUE);
SdShowMsg("Show my message...", FALSE);
SdShowMsg("Show my message...", TRUE);
SdShowMsg("Show my message...", FALSE);
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 13, 2009
10:18 AM
Thanks, that did the trick!
Tim
Tim
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)