Hello,

Version 4.5Ai

Select * from Table1
where condition1
order by 1,2,3

TIBOQuery.RecordCount returns correct value

However

Select * from Table1
where condition1
union
Select * from Table1
where condition2
order by 1,2,3

TIBOQuery.RecordCount aborts and raises exception

ISC ERROR CODE:335544569
SQL error code = -104
Invalid command
count of column list and variable list do not match

The RecodCount call is generated by QReport in Page x of y calculations

What is the solution, if any ?

Best Regards
Hans