Re: [WiX-users] and escape sequences.

2007-05-08 Thread Dhaval Patel
error message was during a CREATE PROCEDURE which has nothing to do with the table creation and the existing table does have that column defined. *From:* Mike Dimmick [mailto:[EMAIL PROTECTED] *Sent:* Monday, May 07, 2007 4:38 AM *To:* 'Kevin Burton'; wix-users@lists.sourceforge.net *

Re: [WiX-users] and escape sequences.

2007-05-08 Thread Albert van Peppen
2007 15:56 Aan: 'Mike Dimmick'; wix-users@lists.sourceforge.net Onderwerp: Re: [WiX-users] and escape sequences. Thank you for your response. I will look into adding "GO" statements. I was just taking the script generated by SMO. Maybe it needs to be modified. As far as

Re: [WiX-users] and escape sequences.

2007-05-07 Thread Kevin Burton
CTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Burton Sent: 07 May 2007 01:05 To: 'Mike Dimmick'; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] and escape sequences. I also get errors like: Error 26204. Error -2147217900: failed to e

Re: [WiX-users] and escape sequences.

2007-05-07 Thread Mike Dimmick
f Of Kevin Burton Sent: 07 May 2007 01:05 To: 'Mike Dimmick'; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] and escape sequences. I also get errors like: Error 26204. Error -2147217900: failed to execute SQL string, error detail: Must declare the scalar variable "@Birth

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Rob Mensching
ke Dimmick'; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] and escape sequences. I am using 2.0.5280. The scripts don't work and I get some weird error messages. The reason that I think Wix is do some substituitions is I see lines like: ExecuteSqlStrings: Error 0x80040e14: f

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Kevin Burton
QUOTED_IDENTIFIER to OFF. -- Mike Dimmick _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Burton Sent: 06 May 2007 01:12 To: wix-users@lists.sourceforge.net Subject: [WiX-users] and escape sequences. I have a task in my Wix file (.wxs) and as best as

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Kevin Burton
ot right? Kevin From: Mike Dimmick [mailto:[EMAIL PROTECTED] Sent: Sunday, May 06, 2007 12:53 PM To: 'Kevin Burton'; wix-users@lists.sourceforge.net Subject: RE: [WiX-users] and escape sequences. What version of WiX are you using? I'm looking at the CA code for SqlScr

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Mike Dimmick
Burton Sent: 06 May 2007 01:12 To: wix-users@lists.sourceforge.net Subject: [WiX-users] and escape sequences. I have a task in my Wix file (.wxs) and as best as I can tell it treats all of the [xxx] as properties so the SQL script does not run. Does anyone have a solution on how I can run a vali

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Rob Mensching
The SqlScript is sent "as is". Only SqlStrings are processed for Properties and thus must be escaped. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Burton Sent: Saturday, May 05, 2007 5:12 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] and escape

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Kevin Burton
to ? -Original Message- From: Sebastian Brand [mailto:[EMAIL PROTECTED] Sent: Sunday, May 06, 2007 10:52 AM To: Kevin Burton Cc: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] and escape sequences. Hello Kevin, As far as I know you can add a backslash to the bracket (-> \[

Re: [WiX-users] and escape sequences.

2007-05-06 Thread Sebastian Brand
Hello Kevin, As far as I know you can add a backslash to the bracket (-> \[xxx\] ) to avoid the handling as properties. It may also be required to enclose the sql command into a CDATA block. Best regards, Sebastian Brand Instyler Software - http://www.instyler.com On May 6, 2007, at 2:11 A

[WiX-users] and escape sequences.

2007-05-05 Thread Kevin Burton
I have a task in my Wix file (.wxs) and as best as I can tell it treats all of the [xxx] as properties so the SQL script does not run. Does anyone have a solution on how I can run a valid SQL script with WIX? Ideally I would like Wix to send the stream as is to the SQL engine and execute it withou