Hi all

Not sure if im asking this in the correct area, im trying to find a way to run a delete query on a msi and cascade the delete across all the joining tables.

For example if i delete a component from the component table i also want it to delete the references in the file table etc.. I know you can do this via instEd by enabling Row Referencing but i need to be able to do this via a vbs.



0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



I would consider it a matter of running the appropriate queries against the MSI using WIRunSQL.vbs (part of the Windows Installer SDK). On deleting a component for example, you would take a note of the component name, then run a query on the file table identifying and deleting all lines referencing this name.

For some good examples of these queries have a look here: http://msdn.microsoft.com/en-us/library/aa368562.aspx


Answered 09/28/2012 by: pjgeutjens
Red Belt

Please log in to comment