/build/static/layout/Breadcrumb_cap_w.png

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


0 Comments   [ + ] Show comments

Answers (1)

Posted by: pjgeutjens 11 years ago
Red Belt
0

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

 

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ