Limiting the rows in a query

[Shahine]

Hi...

Is there a way of globally limiting the number of rows that are returned by all queries?

Something similar to MAX ROWS in BDE?

I have used "QueryAllRecords=False" and "ReadBuffer=25" and it works fine on individual queries but when I use Report Builder (with DOA) I get multiples of 25 Row queries being executed (according to the OracleMonitor).

Since I cannot find a way of changing the Report Builder (DOA) unit, is there a global (default) value that I can set for the ReadBuffer?

Ideally I would like form queries to have a readbuffer = 25 and report queries to have a readbuffer = -1

Many Thanks

Shahine Ghanbarzadeh
Development Manager
Compucorp Ltd.

 

[Marco Kalter]

ReadBuffer merely controls the number of records that are fetched from the server in one network roundtrip. It is a performance optimization feature, which does not affect your application logic.

There are basically 2 ways to define a maximum number of rows for a TOracleDataSet query.

The first is to add a "where rownum