[wix-users] custom table access.

[Bill Wandel]

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

 

https://docs.microsoft.com/en-us/windows/desktop/msi/sql-syntax

 

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:

Hi,



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.



Thanks,

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/