Page 1 of 1

Record count mysteries

Posted: Thu 20 May 2010 05:57
by pwatel
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

Posted: Thu 20 May 2010 07:28
by Dimon
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.