Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-11 Thread Eitan Behar
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,

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-11 Thread Christopher Karper
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

[WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread Nic Barden
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

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread Christopher Karper
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,

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread David Reed (SQL)
Sent: Thursday, August 07, 2008 14:40 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 There is not anything built in to Wix right now that will let you use variables in SqlScripts. You