Hi, I am willing to write the CA. Some writing using DFT sounds cool. But, the only solution that comes to my mind is: loop through the Binary table, export every Sql script, do a find and replace, import the Sql script back to the database. My scripts are pretty long, and I don't want to paste them into wix every time I change it. I prefer the approach, change script, push red button "build and deploy".
If you think about an easier way to custom action it, I will appreciate it. Thanks, Eitan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Karper Sent: Monday, August 11, 2008 8:10 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0 No, you're right, you can only assign explicit scripts. By "load", I meant copy & paste. The two elements have different capabilities, and unfortunately for you, you're looking for one that's only available with SqlString. You either have to cut & paste your statements into the .wxs, or write your own CA to do the work. Chris On Mon, Aug 11, 2008 at 9:31 AM, Eitan Behar <[EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------------------- 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
