Record count mysteries
Posted: 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
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