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
- :
- How to control execution of 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
‎Jul 21, 2008
10:41 AM
How to control execution of SQL scripts?
I have multiple SQL scripts in the SQL scripts view. I want to execute only some of the SQL scripts based on the user input. How can I do it? I am working in INstallscript MSI project and using IS 2008 premier edition.
Thank you.
Thank you.
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 21, 2008
11:08 AM
you can set the scripts to execute by moving them to components that are being installed based on user input.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 21, 2008
11:20 AM
Thanks Peter.
That's a great idea.
That's a great idea.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 21, 2008
03:22 PM
Hello,
Here is a link that may also give you some ideas. I have created a library of functions using ADO objects within install shield (IS). I can execute SQL files, run queries versus the database to get data, and if the SQL errors, I can also get the error message from the SQL server. If you would like to know more, please let me know.
Here is a link that may also give you some ideas. I have created a library of functions using ADO objects within install shield (IS). I can execute SQL files, run queries versus the database to get data, and if the SQL errors, I can also get the error message from the SQL server. If you would like to know more, please let me know.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)