Not brackets or quotes, but in grave characters `Key` . Backtick, peckmark, backquote, whatever that thing gets called in your locale.
Phil Wilson -----Original Message----- From: Thom Leigh [mailto:t...@mondago.com] Sent: Monday, January 31, 2011 9:25 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] FW: Not able to read the Registry Key value of the MSI Is Key a keyword and therefore needs to be placed in square-brackets or quotes? I'm confused though - why does the error say that your query is "SELECT [Registry], [Key] FROM Registry" but your query is only "SELECT Key FROM Registry"? *shrug* -----Original Message----- From: Subhasree Ramesh [mailto:subhasree.ram...@live.in] Sent: 31 January 2011 17:08 To: WIX Toolkit Subject: [WiX-users] FW: Not able to read the Registry Key value of the MSI Hi, I was trying to read the Registry Key value of MSI. Below is the code I used for the same: object[] o = null; IList resultRegisteries = database.ExecuteQuery("Select Key FROM Registry", o); On executing this code, I am getting the following exception: SQL query syntax invalid or unsupported. Database: D:\Projects\msiContents\AdobeReader_930\Package\AcroRead.msi. Column '[Registry]' not present or ambiguous in SQL query: Select [Registry],[Key] FROM Registry. But I am able to read all the values of the Registry table (including the values of Column 'Key') using the below code. IList resultRegisteries = database.ExecuteQuery("Select * FROM Registry", o); I understand that I am missing something on the syntax. Can someone tell me the right syntax? Appreciate your help. Thanks, Subhasree ------------------------------------------------------------------------ ------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 7AW (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77. You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail recept...@invensys.com. This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
