Wrong Record Count Returned in the Data Grid of SQL Editor Window When Using Set Schema Toolbar (4310079)

TOAD returns an incorrect Record Count from the data grid of the SQL Editor Window when the "Set Schema" toolbar is used to point to a different schema. The data grid is populated correctly, but Record Count appears to be ignoring the Set Schema value and executes based solely on the connected user account.

For example, user A is connected and executes the following statement returning no values:

SELECT * from EMP;

User A then sets the schema to user B and executes the same query as above returning 14 records. Instead of displaying a Record Count of 14, TOAD displays zero (0) representing user A and not user B.

WORKAROUND:

None

STATUS:

Issue fixed in version 9.0. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp