Devart Forums

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.

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

Did you read about FetchAll = False limitations?