Skip to content

Query works on Access Database but not work in node-adodb #462

Open
@frmichetti

Description

@frmichetti

I have a query nested inside my database working perfectly. When I try to run on node-adodb it doesn't return any results and also doesn't show any error.

Query source table [All Games List API]:
SELECT * FROM (SELECT [Origin Games].idx AS idx,[Origin Games].title AS title, "Origin" AS system, CBOOL([Origin Games].finished) AS finished FROM [Origin Games] UNION SELECT [Steam Games].[appid] AS appid, [Steam Games].[title] AS title, "Steam" AS system, CBOOL([Steam Finished].finished) AS finished FROM [Steam Games] INNER JOIN [Steam Finished] ON [Steam Games].[appid] = [Steam Finished].[appid] UNION SELECT [Wii GC Games].idx AS idx,[Wii GC Games].title AS title, [Wii GC Games].iso_type AS system, CBOOL([Wii GC Games].finished) AS finished FROM [Wii GC Games] UNION SELECT [WiiU Games].idx AS idx, [WiiU Games].title AS title, "WiiU" AS system, CBOOL([WiiU Games].finished) AS finished FROM [WiiU Games] UNION SELECT [Ubisoft Games].idx AS idx, [Ubisoft Games].title AS title, "Ubisoft" AS system, CBOOL([Ubisoft Games].finished) AS finished FROM [Ubisoft Games] ) AS ALL_GAMES ORDER BY ALL_GAMES.title, ALL_GAMES.system;
This query works perfectly.

Now when I try to run the following query in ado-db:

SELECT * FROM [All Games List API] WHERE title Like "*Assa*";
No error is returned and no data is returned. But when executing this query inside the database it works normally.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions