Automatic fetching

[Peter Zolja]

Hi guys,
I want to be able to run a query, but only return a few rows in a DBGrid; then when the user wants to fetch the rest of the rows it should happen automatically -- like in SQL Navigator, or even PLSQL Developer but more automated.

How can I do this with DOA?

I'm (very) new to DOA, but I haven't seen anything like this in the demos. If there is a demo that would do this please point me to it.

Thanks.

 

[Marco Kalter]

If you are using a TOracleDataSet, then you can simply set the QueryAllRecords property to False. Records will only be fetched when a data-aware control (or another application component) requests them.

Note that the actual fetching also depends on the ReadBuffer property. If you set it to 100, then 100 records will be fetched initially. When the user or the application requests record 101, an additional 100 records will be fetched. Higher ReadBuffer values reduce the number of network roundtrips.

 

[Peter Zolja]

Thanks, that did it...