Page 1 of 1

Conditional SQL script Execution

Posted: Sat Jan 16, 2010 7:33 am
by prezmer
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

Posted: Sun Jan 17, 2010 6:18 am
by bokkie
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.