It's the most legal way of doing it with an msi db -- grave stone tic marks around table/col names and regular tic marks around values. I think it's some constraint issue with the msi db.
-----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Wills Sent: Wednesday, October 04, 2006 8:29 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] msi sql Alex, The quotes look odd, at least on my email reader. Compare the quotes around ControlCondition with those around Hide. Seeya Matthew Wills | Senior Analyst Programmer | Adviser Tools and Services| Financial Planning and Third Party | NAB Technology | Wealth Management Australia |---------+----------------------------> | | Alex Smotritsky | | | <alex_smotritsky@| | | YAHOO.COM> | | | | | | | |---------+----------------------------> >--------------------------------------------------------------------------- -----------------------------------| | | | To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM | | cc: | | 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 email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ =================================== This list is hosted by DevelopMentor. 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
