[WiX-users] Escape single quote in a SQL Statement for MSI database

2010-06-08 Thread Uma Harano
Hi, I am trying to execute the following SQL statement on my msi database: cscript WiRunSQL.vbs MySetup.msifile:///\\emus\emus2\SetupTools\MsiTools\WiRunSQL.vbs%20MySetup.msi UPDATE `ActionText` SET `ActionText`.`Description` ='Configuration de [ProductName]... L'opération peut prendre

Re: [WiX-users] Escape single quote in a SQL Statement for MSI database

2010-06-08 Thread Rob Mensching
From the MSI SDK SQL Syntax: The Windows Installer* SQL syntax does not support the escaping of single-quotes (ASCII value 39) in a string literal*. However, you can fetch or create the record, set the field with the *StringData* or *IntegerData*property, and then call the *Modify* method.