In case anyone's still wondering how to modify the in-memory copy of the MSI database here are some pointers.
You can't do much with using SQL command to modify the database (using UPDATE, DELETE, ...). If you want to modify a existing row, do the following. First, open up the view containing the row you want to work on using SELECT command, you can find more info on MSDN as to how to do this. Search for "MSI Database." Next, delete the row using MsiViewModify function (with MSIMODIFY_DELETE flag). And then add a row with the updated information using MsiViewModify function (with MSIMODIFY_INSERT_TEMPORARY flag). For some implementation reasons that I don't know about MSIMODIFY_UPDATE or MSIMODIFY_REPLACE flags won't work. The udpated row (technically deleted and then added) will stay for the duration of the installation. But what sucks is that you can't delete a row of the table that other tables make references to, like Component table, which I wanted to modify in the first place. As Alex mentioned before, I originally wanted to modify the "Attributes" column of the Component table to change the bitness of the component according to the bitness of the host OS in the run-time, but it seems that I need to find other way around. I've also considered having two components with OS checking conditions within each of them to achieve this, and this would definltey work, but maintaiing two seperate components would be pain in the rear in the future. If I find a clearner solution I'll post it here. Pleaese feel free to suggest what you feel would be a good solution :) -- View this message in context: http://n2.nabble.com/Modifying-MSI-database-during-installation-help%21-tp2825767p2843397.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
