[wix-users] Update ActionText table in MSI DB using Immediate CA before LaunchConditions

[Ven H]

Hi Nir,

Thanks a lot. I tried using DELETE and INSERT methods in the Custom Action.
Even though, I didn't get any errors, it still shows those messages during
installation even when I am deleting some existing records from the
ActionText table and insert them again with blank values for Description
and Template columns into the ActionText table through a CA triggered
before Launch Conditions. Not sure what's wrong.



On Wed, Jul 25, 2018 at 9:23 AM, Nir Bar via wix-users <
wix-users at lists.wixtoolset.org> wrote:

> You can do DELETE and INSERT TEMPORARY queries. Can't do UPDATE. Use my
> WiX extension https://www.nuget.org/packages/PanelSwWixExtension/
> <PanelSW:MsiSqlQuery Id="Test3" Query="DELETE FROM `File` WHERE
> `File`.`File`='Test'">             SOME_CONDITION
> </PanelSW:MsiSqlQuery>     <PanelSW:MsiSqlQuery Id="Test4" Query="INSERT
> INTO `File` (`File`, `Component_`, `FileName`, `FileSize`, `Version`,
> `Language`, `Attributes`, `Sequence`) VALUES ('Test', 'Test',
> 'Product.wxs', '1875', '65535.65535.65535.65535', '', '512', '1')
> TEMPORARY">             SOME_CONDITION     </PanelSW:MsiSqlQuery> -- Nir
> Bar, Independent WiX Expert. Creator of- JetBA: WiX WPF Bootstrapper User
> Interface Framework JetBA++: WiX Native Bootstrapper User Interface
> Framework JetRummikub: Install WiX packages on remote machines
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant
> http://www.firegiant.com/
>