Hi,
I am new to wix and am posting here for the first time. I've creating a
database and running a script to add Tables to it, which is happening
perfectly. Then i am running a script to create a Stored Procedure which
inserts a few rows in some of the tables created, which is also working
fine. Then i try to Execute the stored procedure using SqlString element.
Though it is not showing any error and installation is happening
succesfully, the insert is not happening in any of the tables. I am
attaching the code for creating and executing the Stored Proc for reference:
<Binary Id="UpdateProcedure"
SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" />
<Sql:SqlScript Id="UpdateDb" BinaryKey="UpdateProcedure"
ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" SqlDb="masterDb"/>
<Sql:SqlString Id="ExecuteProc" ExecuteOnInstall="yes"
ContinueOnError="no" RollbackOnUninstall="yes" Sequence="2" SqlDb="masterDb"
SQL="exec sp_InstallDefaults"/>
I am unable to figure out where i am going wrong. Any help wouldbe really
appreciated.
TIA
Rahul
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
