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
