Help me with FetchAll and QueryRecCount please

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Oleksiy

Help me with FetchAll and QueryRecCount please

Post by Oleksiy » Mon 28 Nov 2005 14:44

Why I can't use select query in columns list where FetchAll property equal False and Options.QueryRecCount equal true? TMSParser return the next incorrect query:
(SELECT COUNT(*) FROM Table1 as Table1) as Column1 FROM Table2 as Table2
The starting query:
SELECT Column2, (SELECT TOP 1 Column1 FROM Table1 as Table1) as Column1 FROM Table2 as Table2.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 29 Nov 2005 13:27

SQL Generator is intended only for simple queries and can't parse subqueries.

Did you read about FetchAll = False limitations?

Post Reply