fetch all

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Guest

fetch all

Post by Guest » Tue 28 Dec 2004 10:26

Hi there,

Does the corelab component manage the limits when a query retrieves many records ?

I don't want to retrieve the thousands of records but still I wanna browse them ... using a buffering technique or something like that ...

best regards,

Etienne

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 28 Dec 2004 10:45

Is it question about ODAC, MyDAC, SDAC?

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 28 Dec 2004 17:15

In ODAC, we suggest you to set ScrollableCursor option of DataSet object to True, in this case TOraDataSet does not cache data on the client side but uses scrollable server cursor.
This feature is supported starting from Oracle server 9i. If you need more info pls. see ODAC help, topic TOraDataSet.OptionsDS.
You can set TOraDataSet.UniDirectional=True. ODAC will use one memory block for all records. But you cannot use such dataset with TDBGrid.

Post Reply