[wix-users] custom table access.

Bill Wandel bill at bwandel.com
Mon Jan 14 09:12:56 PST 2019

Thanks. I also tried a column name instead of the ‘*’, SELECT ‘column’ from ‘table’


Bill Wandel


From: Edwin Castro <egcastr at gmail.com> 
Sent: Monday, January 14, 2019 11:49 AM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Cc: Bill Wandel <bill at bwandel.com>
Subject: Re: [wix-users] custom table access.


For details on the SQL syntax supported by the Windows Installer please refer to




I think the problem you're running into is that you have single quotes around the asterisk. The Windows Installer interprets anything in single quotes as a constant and a constant isn't allowed between SELECT and FROM.



Edwin G. Castro



On Mon, Jan 14, 2019 at 7:08 AM Bill Wandel via wix-users <wix-users at lists.wixtoolset.org <mailto:wix-users at lists.wixtoolset.org> > wrote:


I have a custom table and a custom action where I want to access this table.
My OpenView query string is "SELECT '*' FROM table"  I get a "SQL query
syntax invalid or unsupported" exception. Before I do this query I call
db.CountRows on this table and it returns the correct number of rows.

I don't know where to go from here.


Bill Wandel

bill at bwandel.com <mailto:bill at bwandel.com>  <mailto:bill at bwandel.com <mailto:bill at bwandel.com> > 

WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

More information about the wix-users mailing list