[wix-users] custom table access.

[Edwin Castro]

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> 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>
>
>
>
>
>
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant
> http://www.firegiant.com/
>