fetch all

fetch all

Postby 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
Guest
 

Postby Paul » Tue 28 Dec 2004 10:45

Is it question about ODAC, MyDAC, SDAC?
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to VirtualDAC