Kbase P126580: DB Navigator does not retrieve more than 2000 records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1x
Windows
SYMPTOM(s):
DB Navigator does not retrieve more than 2000 records
Running a SQL query using Select * from pub.<table>
Table contains more than 2000 records
CAUSE:
SQL Results row limit specifies the number of rows to return after execution of SQL Select statements. The range is 100 ? 5000. The default is 2000.
FIX:
The number of rows displayed can be set in the SQL Results row limits field of the DB Navigator preferences dialog.