Phil,
That works :-) Thank you
Thom,
Placing it in the square brackets or within quotes did not help.
There is a column by name "Registry" inside the Registry table. Since I need
the value of columns Key and Registry from the Registry table I had that
query.
> From: phil.wil...@invensys.com
> To: wix-users@lists.sourceforge.net
> Date: Mon, 31 Jan 2011 13:10:34 -0500
> Subject: Re: [WiX-users] FW: Not able to read the Registry Key value of the
> MSI
>
> 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
------------------------------------------------------------------------------
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
