[wix-users] MSI database update at install time

[Edwin Castro]

The Windows Installer does not allow you to delete/modify rows in custom
actions.

You can add temporary rows using an immediate custom action.

Why do you think you need to update rows at install time? Perhaps you can
use Formatted strings and properties instead?

--
Edwin G. Castro

On Wed, Nov 11, 2015 at 2:40 PM, Stephen Woolhead <stephen at perfectphase.com>
wrote:

> Hi, I writing a WiX extension and one of the steps I need my custom
> actions to do is update existing records in the MSI database at install
> time.
>
>
> After a bit of research it appears that I can't use SQL UPDATE on
> permanent tables at install time. Blog posts I've seen [1] say that I need
> to delete and insert a new row, but when I try this I get the following
> errors:
>
>
> Ready to execute delete query: DELETE FROM `IIsAppPool` WHERE
> `IIsAppPool`.`AppPool`='web_general_apppool'
> Delete Query Executed Successfully
> Ready to execute insert query: INSERT INTO `IIsAppPool` (`AppPool`,
> `Name`, `Component_`, `Attributes`, `User_`, `RecycleMinutes`,
> `RecycleRequests`, `RecycleTimes`, `IdleTimeout`, `QueueLimit`, `CPUMon`,
> `MaxProc`, `VirtualMemory`, `PrivateMemory`, `ManagedRuntimeVersion`,
> `ManagedPipelineMode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) TEMPORARY
> Executing insert query...
> MSI (s) (B8!D0) [22:33:20:906]: Database string pool is corrupted.
> MSI (s) (B8!D0) [22:33:20:906]: Note: 1: 2259 2:  3:  4:
> Exception Type: Microsoft.Deployment.WindowsInstaller.InstallerException
>
>
> Is this possible or am I heading down a blind end?
>
>
> Cheer,
>
>
> Stephen.
>
>
>
>
> [1]
> http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Updating-msi-database-install-time-tp7587512p7587523.html
>
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant
> http://www.firegiant.com/
>