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

Comments

Please log in to comment

Answers

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

 

Answered 09/28/2012 by: pjgeutjens
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity