Microsoft KB Archive/69230

PRB: Continuing a SQL Query After “Rows Pending…” Message

PSS ID Number: Q69230 Article last modified on 12-18-1992

1.10 1.11 4.20 | 1.10 1.11 4.20 MS-DOS | OS/2

Summary:

SYMPTOMS When using a SELECT statement in SAF to retrieve rows from a table in SQL Server, if more than 3,000 rows from the table are qualified by the query, SAF returns the first 3,000 rows, stops, and displays the message “Rows pending…” in the lower-left corner of the screen. The remaining results cannot be obtained. Using CTRL+N to clear the query does not work: the “Rows pending…” message remains, and you cannot issue another query.

RESOLUTION When the query appears to stop and the “Rows pending…” message is displayed, press CTRL+END to alert SAF to display the remaining rows. Pressing CTRL+END causes SAF to retrieve all remaining rows, discarding rows from the top as necessary. This process can seem considerably slower than usual. To speed up the retrieval time, press F6 twice, and then press CTRL+END again. The rows should now be returned at a normal speed.

= Additional reference words: SAF pending =

Copyright Microsoft Corporation 1992.