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=77nav_id=80prev_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