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
jjmorlan
Posts: 11
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.

Stellar
Devart Team
Posts: 496
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