This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mayurbirari
Level 5
‎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.
Labels (1)
Labels
0 Kudos
(3) Replies
thepeter
Level 7
‎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.
0 Kudos
mayurbirari
Level 5
‎Jul 21, 2008 11:20 AM

Thanks Peter.
That's a great idea.
0 Kudos
TheTraveler
Level 8
‎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.
0 Kudos