MSI docs do not say anything about creating temporary tables. The usual practice is to author an empty table in the MSI which is then available for custom actions to add temporary rows.
>> the Database that I get access to through the Session object says it has an OpenMode of ReadOnly (however the IsReadOnly property is false)
This is a bug in DTF; I'll fix it soon. The MsiGetDatabaseState() call made by the IsReadOnly property does not get remoted properly from the CA process to the MSI engine. The OpenMode is actually correct -- the Database handle for a custom action Session is always ReadOnly.
-Jason-
-----Original Message-----
From: Rob Mensching [mailto:
Rob.Mensching@...]
Sent: Wednesday, October 08, 2008 12:37 PM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] Create and/or modify MSI database tables via DTF from CA
1. No. The database is read-only while running.
2. I'm not sure you can add temporary tables, maybe.
3. You can add temporary rows.
-----Original Message-----
From: Nic Barden [mailto:
bardo33@...]
Sent: Wednesday, October 08, 2008 12:33
To:
wix-users@...
Subject: [WiX-users] Create and/or modify MSI database tables via DTF from CA
Hi,
I am trying to update the MSI tables at runtime from a Custom Action to
perform token replacement in SQL Script files.
The issue I am running into is that the Database that I get access to
through the Session object says it has an OpenMode of ReadOnly (however the
IsReadOnly property is false).
I believe this is the reason that when I go to update either existing
records, or add any new records, I get an error stating "Function failed
during execution. Database: Table(s) Update failed.".
When I execute the same code from a unit test I can reproduce the issue.
However, when I open the database using a mode of "Transact" then I do not
generate any errors. However, I obviously have no control over how the
database is opened at runtime.
So...
- Can I update EXISTING table data somehow from a CA?
- Can I add my own tables and data from a CA?
- Can I add my own data to existing tables from a CA?
Thanks a lot
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
WiX-users mailing list
WiX-users@...
https://lists.sourceforge.net/lists/listinfo/wix-users-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
WiX-users mailing list
WiX-users@...
https://lists.sourceforge.net/lists/listinfo/wix-users-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
WiX-users mailing list
WiX-users@...
https://lists.sourceforge.net/lists/listinfo/wix-users
