Subject | BUG IN PROCEDURE |
---|---|
Author | todderamaa |
Post date | 2002-06-07T14:35:39Z |
I have a procedure that isn't returning the correct results. In
digging in I find that the following statement:
FOR SELECT Priority, Count(imprid)
FROM RapBuilding
WHERE RapID = :RapID
GROUP BY Priority
INTO :bldgPriority, :ImpCount
DO
BEGIN
/* STUFF */
END
LOOPS through 3 Records (priority 2,3 & 4)
But if I do the same statement with the same RAPID:
SELECT Priority, Count(imprid)
FROM RapBuilding
WHERE RapID = 210021555
GROUP BY Priority
RETURNS 4 Records (priority 1,2,3 & 4)
Is there a known Bug in Interbase regarding this?
Todd
digging in I find that the following statement:
FOR SELECT Priority, Count(imprid)
FROM RapBuilding
WHERE RapID = :RapID
GROUP BY Priority
INTO :bldgPriority, :ImpCount
DO
BEGIN
/* STUFF */
END
LOOPS through 3 Records (priority 2,3 & 4)
But if I do the same statement with the same RAPID:
SELECT Priority, Count(imprid)
FROM RapBuilding
WHERE RapID = 210021555
GROUP BY Priority
RETURNS 4 Records (priority 1,2,3 & 4)
Is there a known Bug in Interbase regarding this?
Todd