WITH clause in SELECT statement

Schlueter · Post by **Schlueter** » Wed 28 May 2014 09:42

Hi,
does LiteDAC support the WITH clause in a SELECT statement?

WITH RECURSIVE
cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000)
SELECT x FROM cnt;

Best regards
Rolf Schlueter

AlexP · Post by **AlexP** » Wed 28 May 2014 10:23

Hello,

This feature is supported by the SQLite library since SQLite3.dll version 3.8.4. In the Direct mode, this feature is supported since the latest LiteDAC version 2.3.7.

Schlueter · Post by **Schlueter** » Wed 28 May 2014 13:17

Yes, it works!

Thanks
Rolf

AlexP · Post by **AlexP** » Thu 29 May 2014 07:48

You are welcome. Feel free to contact us if you have any further questions.

Devart Forums

WITH clause in SELECT statement

WITH clause in SELECT statement

Re: WITH clause in SELECT statement

Re: WITH clause in SELECT statement

Re: WITH clause in SELECT statement