Now I see what you're trying to do, this is the set of SQL commands that correspond to http://support.microsoft.com/kb/835460/en-us
And they seem to work fine: delete from `ControlCondition` where `ControlCondition`.`Dialog_` = 'FolderForm' and `ControlCondition`.`Control_` = 'AllUsersRadioGroup' delete from `ControlCondition` where `ControlCondition`.`Dialog_` = 'FolderForm' and `ControlCondition`.`Control_` = 'AllUsersText' delete from `Control` where `Control`.`Dialog_` = 'FolderForm' and `Control`.`Control` = 'AllUsersRadioGroup' delete from `Control` where `Control`.`Dialog_` = 'FolderForm' and `Control`.`Control` = 'AllUsersText' delete from `RadioButton` where `RadioButton`.`Property` = 'FolderForm_AllUsers' update `Control` set `Control`.`Control_Next` = 'CancelButton' where `Control`.`Control_Next` = 'AllUsersRadioGroup' None of this is .NET - you'd find more people jumping on this in microsoft.public.platformsdk.msi. Phil Wilson -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Phil Sent: Wednesday, October 04, 2006 4:56 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] msi sql The column in your SET statement isn't called `ControlCondition`, so it's it's just `Condition`.`Action` Phil Wilson -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Alex Smotritsky Sent: Saturday, September 30, 2006 10:29 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: [ADVANCED-DOTNET] msi sql I can't figure out why the below sql I'm running against my msi file won't work. Cscript WiRunSQL.vbs MyMsi.msi "UPDATE `ControlCondition` SET `ControlCondition`.`Action`='Hide' WHERE `ControlCondition`.`Dialog_`='FolderForm' AND `ControlCondition`.`Control_` = 'AllUsersRadioGroup'" The data I'm trying to change in the msi file is standard data generated by a default msi build from visual studio 2003. =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
