I have the following SQL statement:

SELECT Type, Action, Count(Action) AS 'Total'
FROM security_AccessLog
GROUP BY Type, Action
ORDER BY Total DESC"

This should return 17 records in my case.

When this is called using x.dbSQL I get only 4 records displayed. I can re-sort the columns and view the other records, but only 4 are displayed. ie "Rec [1 to 4] of 4"

When I call this via the same sql but within a stored procedure using x.dbStoredProc I get the correct number of records returned. ie

"Rec [1 to 17] of 17"

I have set a unique dbUnit but cannot figure out why there is a difference.