Record count mysteries

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pwatel
Posts: 39
Joined: Wed 11 Feb 2009 09:42

Record count mysteries

Post by pwatel » Thu 20 May 2010 05:57

hello
I have this TIBC query select
SELECT DISTINCT
COP.NDX,
COP.COMPOSER
FROM
COMPOSERS COP
INNER JOIN TITLES T ON (T.COMPOSERNDX = COP.NDX)
WHERE
(T.PERIODNDX = 4)
ORDER BY
1
I have set Fetchall:= false; but QueryRecCount := true;
when I check Q.recordCount the answer does not make sense at all
this query is easy It should be able to compute the rec count of course if I say Fetchall := true then I get the correct number but if defies the purpose or I do not know what I am doing which is also a possibility
Please any help would be great
thank you
PW

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 20 May 2010 07:28

I can not reproduce the problem.
Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com, including script to create database objects.

Post Reply