-
SQL Server & ASPDB Problems
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|