Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 4

Running SQL Script through installscript


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?


Labels (1)
0 Kudos
(1) Reply
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
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