Devart Forums

Posted: **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

Posted: **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.

Posted: **Wed 28 May 2014 13:17**

Yes, it works!

Thanks
Rolf

Posted: **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