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

2008-08-11 Thread Eitan Behar
Windows Installer XML toolset. Subject: Re: [WiX-users] Dynamically naming a database during its installation I built an extension that uses SqlFormattedScript elements. It's basically just SqlScript, plus formatting. I used the same design, up to and including the table it stores into i

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

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

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

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

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 y

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, Christ

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

2008-08-07 Thread David Reed (SQL)
ROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Karper 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

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, Nic

[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 l

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

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