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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 12:33 To: wix-users@lists.sourceforge.net 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@lists.sourceforge.net 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@lists.sourceforge.net 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users