Conditional SQL script Execution

prezmer · Post by **prezmer** » Sat Jan 16, 2010 7:33 am

Hello,

Is it possible to to execute SQL scripts conditionally? I would like to have a setup with 2 different installation modes. User decides using radio box which mode to use. In case of DB based mode, SQL scripts should be executed

best regards
Piotr Rezmer

bokkie · Post by **bokkie** » Sun Jan 17, 2010 6:18 am

Piotr, you have partially answered the question already. If you are linking your choice to radio buttons then you can check the status of the one selected and in that piece of code take whatever action is appropriate to your needs. How to execute the SQL is another thing. If you are using SQL Server you can feed a script into the osql.exe command. I think IA has something builtin that can do SQL related tasks but I've never used them. So, in short, it's possible to determine what you want to do.