5 replies to this topic

[sanjoygr]

Basic MSI project created using Install Shield Version 11.0

Created a single SQLConnection1, provided the requirements.
Now added a few SQLScript1, SQLScript2,SQLScript3.

I want to put condition which will allow only one SQLScript to run out of the bunch of SQLScripts file.

Please let me know how to accomplish it. At least give some hints.

Thanks
Sanjoy

[Stefan Krueger]

Have you tried the Condition field in the SQL Script settings?

[sanjoygr]

Thanks Stefan,
I think the problem can be solved using condition filed in SQL script.

However it would be better if I could put condition in my install shiled basic msi based on which could have called different SQL scripts as per requirement.

Thanks
Sanjoy

[Stefan Krueger]

I guess I don't understand what you're trying to do.
You can have multiple SQL script and select which one to execute using these conditions.

[sanjoygr]

Yes Stefan,

I am having multiple sql script and select one of them to execute depending upon some condition like 1st time installation or updation.

I thought of following way to do so.
However I do not know If I am correct.

1. Create two property using property manager
eg optScriptUpdate and optScriptNew both initialize to 0.

2. Put a RadioButton Group in SQLLogin Dialog

3.Depending upon which Option the user selects, the particular script will be executed depending upon "Specify condition statement" example optScriptUpdate=1

Thanks
Sanjoy

[Stefan Krueger]

Yes, that should work.