instTst
Level 4

Running SQL Script through installscript

Hi,

I was wondering if there was a way to run a SQL script that is in my support files directory, through installscript. I don't want to use the SQL script view because it does not allow for the flexibility that I require.

What I want to do is something like this:

runSql(SUPPORTDIR ^ "sqlscript.sql");

Is there a function that lets me do something like this?

Regards,

J
Labels (1)
0 Kudos
1 Reply
weakness
Level 6

Apparently, you have to use "SQL Scripts view" if you want to use InstallScript SQL build in functions....

Using the SQL Run-Time Functions in InstallScript and InstallScript MSI Projects
http://kb.flexerasoftware.com/doc/Helpnet/InstallShield2011/SQLRTSupport.htm
The SQLRT functions require that you configure SQL information through the SQL Scripts view; the configuration information is written to the SQLRT.ini file so that the SQL run-time functions work properly.
0 Kudos