Page 1 of 1

QueryRecCount and WITH statement

Posted: Fri 11 Nov 2011 13:15
by mvictor
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

Posted: Fri 11 Nov 2011 13:41
by AndreyZ
Hello,

Please specify the exact database server you are working with.

Posted: Fri 11 Nov 2011 13:50
by mvictor
db firebird 2.5.1

Posted: Fri 11 Nov 2011 14:11
by AndreyZ
Thank you for the information. We will fix this problem in the next UniDAC build.