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. Alter

[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.msi "UPDATE `ActionText` SET `ActionText`.`Description` ='Configuration de [ProductName]... L'opération peut prendre plusieurs minutes.' WHERE `ActionText`.`Description`= 'Configuring [Prod