I'll answer my own question. No, SqlScript does not perform property substitution.
I had thought property substitution rules were being followed when I was troubleshooting an install failure that had a msi log entry like this... ExecuteSqlStrings: Executing SQL string: CREATE TABLE .( IDENTITY(1,1) NOT NULL, NOT NULL, NULL ) After a bit more testing, I realized the issue is the Windows Installer LOGGER, not the WiX SqlScript parser. The Windows installer logger will evaluate [] properties. In this particular case it makes it rather difficult to know what happening within the SQL script. We have been burned by this logger's parsing before, so we make sure all of our log statements do not make use of [] characters. Guess I'll either need to live with it, or change the quotation syntax in our SQL scripts. Thanks for listening... On Mon, Jun 2, 2014 at 1:47 PM, Tony <yellowjacketl...@gmail.com> wrote: > Does the SqlExtension's SqlScript processing use installer property > substitution rules? > > IOW, if my script contains... > > CREATE TABLE [MyDatabase].[MyTable]( > [MyId] [int] IDENTITY(1,1) NOT NULL, > [CreatedOn] [datetime] NOT NULL, > [CreatedBy] [nvarchar](256) NOT NULL > ) > > Am I expected to escape all of the bracket characters? > > -- > Tony > -- Tony ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
