WITH clause in SELECT statement

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Schlueter
Posts: 14
Joined: Thu 29 Aug 2013 06:57

WITH clause in SELECT statement

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: WITH clause in SELECT statement

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
Posts: 14
Joined: Thu 29 Aug 2013 06:57

Re: WITH clause in SELECT statement

Post by Schlueter » Wed 28 May 2014 13:17

Yes, it works! :D

Thanks
Rolf

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: WITH clause in SELECT statement

Post by AlexP » Thu 29 May 2014 07:48

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

Post Reply