Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Bind grid to recordset whith OraOLEDB Provider for ADO
Hi!
I'm using the OraOLEDB Provider (from ORACLE) to access data in an 7.3
Oracle
database with ADO. This provider implements a server side cursor, which
is bookmarkable and updateble.
When I use the server side cursor only to fill the edit controls on my
dialog by
hand, the execution of my query returns at once without fetching the
whole result to the client.
When I bind my grid control (Apex TRUE OLE DBGrid 6) to the recordset,
the whole amount of data is transferred to the client:
m_TrueGrid.SetDataSource( (_Recordset*) mpData->GetRecordset() ); m_TrueGrid.ClearFields(); m_TrueGrid.ReBind();
If I remove the grids "rebind" command, the behaviour is quite amazing:
The mask is shown at once, the visible part of the grid is filled with data from my recordset. But the application can't be accessed cause the grid seems to be fetching the rest of the data in background.
Is there a possibility to prevent the grid from fetching the whole
result to the client?
Or is there a setting for the recordset not to transfer the whole amount
of data?
Thanks a lot
Holger MuellerReceived on Tue Jan 18 2000 - 05:20:56 CST
![]() |
![]() |