[WiX-users] Problems executing SQL script to insert data

I have an MSI that's running a SQL script to insert data (using the SqlScript wix element). The sql script looks like (simplified somewhat): /* table: Version */ /* some comment*/ INSERT INTO [dbo].[Version] ([Object],[Version]) VALUES ('mytool', '2.0.12344.1234')GO /* some comment*/ INSERT

Re: [WiX-users] Problems executing SQL script to insert data

You either need to load them as SqlScript elements from a file, or escape the square brackets according to Formatted String rules. I think it's [\[] and [\]], but you'll want to double check that. Or, you could always wing it, and just run without brackets. You may find it works just fine.

Re: [WiX-users] Problems executing SQL script to insert data

I'm already using SqlScript elements to load them as a file. Kevin Date: Tue, 16 Dec 2008 18:23:30 -0500 From: christopher.kar...@gmail.com To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Problems executing SQL script to insert data You either need to load them as SqlScript

Re: [WiX-users] Problems executing SQL script to insert data

...@gmail.com To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Problems executing SQL script to insert data You either need to load them as SqlScript elements from a file, or escape the square brackets according to Formatted String rules. I think it's [\[] and [\]], but you'll want

Re: [WiX-users] Problems executing SQL script to insert data

2008 18:23:30 -0500 From: christopher.kar...@gmail.com To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Problems executing SQL script to insert data You either need to load them as SqlScript elements from a file, or escape the square brackets according to Formatted String rules. I