Devart Forums

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.

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.