At 02:56 PM 1/02/2005 -0700, you wrote:

>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 ?

None that I know of. Fb/Ib currently doesn't return a RecordCount from
selects. If you ask for one, IBO will (ultimately) try to get one by
attempting to manufacture a SELECT COUNT(*) query internally from the SQL
statement. However, SELECT COUNT(*) queries are not valid for unioned
sets, so there isn't a valid RecordCount query that could be constructed.

In a very awkward way, you could try to calculate a record count in a
routine of your own, by a series of queries. I wouldn't recommend it, though.

Helen