|
GO is not a SQL statement. The query parser inside SQL Server
does not understand it. It is a direction to the client tools (e.g. Query
Analyzer, SQL Server Management Studio, osql.exe, sqlcmd.exe) to send the
current batch of commands to the server – it terminates the batch. In the source for ScaSqlStrsReadScripts in WiX 2.0.4415.0, the GO
keyword is supposed to be detected and the script split into separate strings
to be subsequently executed when the ExecuteSqlStrings custom action is called
(this is scheduled by ConfigureSql which schedules ExecuteSqlStrings once per SqlString
or batch from a SqlScript). Is only the first part of the script running (up to the first GO?)
Are the parts which are executed consecutive, or are some omitted? The CA does send some debugging information to the debug output
(using OutputDebugString); you might see some useful information if you use
DebugView (http://www.sysinternals.com/utilities/debugview.html)
when running the installer. -- Mike Dimmick From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jonas
Abrams We
are using WiX to create an installation for our application. On install,
we are executing some SQL scripts (to create a database and put in sample data)
and it has been working great. Recently, we started using functions with
our database and now we need to run a script that creates functions when
installing. In order to run the script we needed GO statements after each
creation, but with the GOs the script does not execute properly within Windows
Installer. Is there another way to get the script to execute properly in
the Windows Installer using WiX? Thanks, Jonas |
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
