The TOracleDataSet has a QueryAllRecords property. When you set it to False, only the visible records will initially be queried. The default value of this property is True, because we assume that you are always interested in the complete result set. If this is not the case, you should probably modify the where clause of your query.

------------------
Marco Kalter
Allround Automations