Devart Forums

Hello,

Having a ClientDataset, a Provider and a PgQuery with FetchAll=false, along with 2 tables, the following query failed with an error with the text similar with the title.

• with tbl as (Select 'ABC' VAL)
  select a.ID, tbl.VAL
  from tbl1 a
  join tbl2 b on a.ID=b.ID, tbl

If the select in query is from a single table or the query doesn't contain the "with" CTE option or FetchAll=true, the error doesn't raise.

Hello,

We cannot reproduce the problem. Please try to reproduce the problem on the latest PgDAC version 4.2.6

I have sent a mail with a demo.

regards

Thank you, we have received your sample. We will inform you as soon as we have any results.

Issue resolved.
Case closed.

Glad to see that the issue was resolved. If any other questions come up, please contact us.

Hello.

Do you have any information how to resolve this problem? I have exactly the same error.

To solve this issue, download the latest version of PgDAC from our website: http://www.devart.com/pgdac/download.html , and update it. Let us know if the issue is reproduce on the latest version.