Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Bind grid to recordset whith OraOLEDB Provider for ADO

Bind grid to recordset whith OraOLEDB Provider for ADO

From: Holger Mueller <holger.mueller_at_meta-level.de>
Date: Tue, 18 Jan 2000 12:20:56 +0100
Message-ID: <38844C98.F65DC556@meta-level.de>


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 Mueller

Received on Tue Jan 18 2000 - 05:20:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US