CTE Common Table Expression Error

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 9
Joined: Mon 31 Aug 2015 12:29

CTE Common Table Expression Error

Post by jjmorlan » Wed 08 Nov 2017 01:20

Hello, I have put a select that brings me a set of data using CTE but the component gives me this error: Syntax error, permission violation, or other nonspecific error. Does SDAC support the use of Common table expression in a Query object?

Thank you.

Devart Team
Posts: 124
Joined: Tue 03 Oct 2017 11:00

Re: CTE Common Table Expression Error

Post by Stellar » Thu 09 Nov 2017 10:55

SDAC supports a common table expression. Please provide us with a query sample, which demonstrates the issue, as well as with a script to create tables.

Post Reply