I understand
The only thing I could think of is to run the data load by using the "xp_cmdshell" stored procedure from an SQLString rather than as a custom action. But then the xml files will need to be installed on the system first so that you can reference them, which could be a sequencing issue. Are you relying on the XMLFile task to update the xml files first? Michael -----Original Message----- From: Jaap de Wolff [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 July 2006 4:21 PM To: Michael Osmond; wix-users@lists.sourceforge.net Subject: RE: [WiX-users] SqlScript and CustomActions Actually until now I filled the database with sql string actions until now. It had to be an sql strings, because I was using some setup parameters, and the sql strings where > 1000 lines. And because I can do the same job with (existing) xml files and a custom action, this is far more elegant. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Michael > Osmond > Sent: donderdag 13 juli 2006 3:02 > To: Jaap de Wolff; wix-users@lists.sourceforge.net > Subject: Re: [WiX-users] SqlScript and CustomActions > > > Hello Jaap, > > I don't think you can sequence a custom action in between. The SQL > scripts are all executed by a single custom action themselves. > > Can you do your dataload through an slqstring or script instead of via > other custom actions? > > Michael > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jaap de > Wolff > Sent: Thursday, 13 July 2006 12:33 AM > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] SqlScript and CustomActions > > Hello, > > I want to create a database, run an sql script to create tables etc. > then do a few custom actions, which fill the database, and then > execute a few sql strings. > The last sql strings contain values which depend on customer choices. > My question is: > Is there a way of scheduling custom actions between some sql scripts, > and some sql strings? > > Jaap > > > > > ---------------------------------------------------------------------- > -- > - > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier Download IBM WebSphere Application Server v.1.0.1 based on > Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216 > 42 _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > ---------------------------------------------------------------------- > --- Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier Download IBM WebSphere Application Server v.1.0.1 based on > Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216 > 42 _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
