This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
instTst
Level 4
‎Mar 16, 2011 08:14 AM

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)
Labels
0 Kudos
(1) Reply
weakness
Level 6
‎Mar 18, 2011 12:36 AM

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