QueryRecCount and WITH statement

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mvictor
Posts: 9
Joined: Tue 11 Aug 2009 15:38

QueryRecCount and WITH statement

Post by mvictor » Fri 11 Nov 2011 13:15

adding "QueryRecCount" option for select as :

Code: Select all

with xxx as (select fld1,fld_... from same_tbl)
select * from xxx
where xxx.fld1 between 500 and 600
raises error

AndreyZ

Post by AndreyZ » Fri 11 Nov 2011 13:41

Hello,

Please specify the exact database server you are working with.

mvictor
Posts: 9
Joined: Tue 11 Aug 2009 15:38

Post by mvictor » Fri 11 Nov 2011 13:50

db firebird 2.5.1

AndreyZ

Post by AndreyZ » Fri 11 Nov 2011 14:11

Thank you for the information. We will fix this problem in the next UniDAC build.

Post Reply