Windows Installer Delete Cascade?
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.
Thanks
James
Answers (1)
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
