Hi Karma, Actually, after carefully re-reading your question, I don't think you can achieve what you want. Only temporary tables, rows, or columns can be modified. In your case you are trying to modify existing component's 64-bit flag. Won't work. Besides, I think that 32-bit and 64-bit versions of the same component must have different component GUIDs. A better approach would be to provide both 32 and 64-bit versions of component and put proper condition on them. Also, had to refresh my memory. According to http://msdn.microsoft.com/en-us/library/aa372021(VS.85).aspx, TEMPORARY is valid for INSERT INTO only, not for UPDATE. Thanks for being fan of my blog. :-)
Alex -----Original Message----- From: Karma [mailto:dongl...@gmail.com] Sent: Thursday, May 07, 2009 8:39 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Modifying MSI database during installation help! Thank you guys both for so much. But would you explain more on how I can specify my intention of modifying the in-memory copy of the MSI? When using MsiDatabaseOpenView, I tried to use "UPDATE `Component` SET `Component`.`Attributes`='256' WHERE `Component`.`Component`='AuthPluginRegistry' TEMPORARY" as my query command, but it outputtted ERROR_BAD_QUERY_SYNTAX error. Is TEMPORARY some kind of flag that I need to pass through some API? Also is adding rows the only database manipulation that can be performed on a temporary database? What about updating an existing row like one I attempted to do? I would appreciate for your help. And by the way, Alex, I'm a big fan of your blog :) Curtis Jewell wrote: > > This line is the problem. > > "UPDATE `Component` SET `Component`.`Attributes`='SOME_CONSTANT WHERE > `Component`.`Component`=SOME_KEY_NAME" TEMPORARY > > -- View this message in context: http://n2.nabble.com/Modifying-MSI-database-during-installation-help%21-tp28 25767p2829527.html Sent from the wix-users mailing list archive at Nabble.com. ---------------------------------------------------------------------------- -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
