There is not anything built in to Wix right now that will let you use variables in SqlScripts. You can load them into SqlString elements and use the normal [property] syntax.
You can build a CA that will do this as well, which is what I did. Good luck! Chris On Thu, Aug 7, 2008 at 5:01 PM, Nic Barden <[EMAIL PROTECTED]> wrote: > Sorry forgot to mention I am running the latest WiX version - 3.0.4318.0. > And SQL 2005 if that makes any difference. > > > > Hi guys, > > > > I am trying to use the SqlDatabase and SqlScript elements to install a > database and run some scripts to generate stored procs and tables etc. > > What I would ideally like is the user to be able to specify the database > name in the setup UI, and then use that within the scripts. > > The SqlDatabase element has a "Database" attribute which specifies the name > of the database to create, so obviously this can be a WiX variable at > runtime. > > However, inside the sql scripts I need to reference the name of the > database > also. I am unsure whether it is possible to pass parameters into the > script > at run time? > > > > How would this task normally be achieved? Do we have to hard code the > database name and then manually change it? :-( > > > > Thanks for your help! > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------- 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
