Hi, Please, can you expand a little more on how to load the scripts into a sqlstring and use the properties?
I only saw how to assign SqlString explicit scripts, and not reading the scripts from a .sql file in the Binary table. Thanks in advance, Eitan On Fri, Aug 8, 2008 at 12:40 AM, Christopher Karper < [EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------------------- 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
