Subject Re: [IBO] IBO4 and ParamByName
Author Lester Caine
> As for the COUNT column issue, I am not clear on what the problem is. Can
> you elaborate just a bit?

I have a simple query that just counts the number of records so I can do a
percentage seen

SELECT COUNT(*) FROM TICKETS WHERE ( filter bit )

IBO4 assigns the field name "COUNT" where IBO3.6 correctly used COUNT.

This then causes a problem in FastReport where it uses "COUNT" to separate the
field name from the table details.

The disapearing grids are more of a problem, when I have that I will add an 'AS
CNT' and rebuild the reports to use 'CNT'.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services