Re: Binding grid to recordset with MSDAORA provider for ADO

As far as I know, you have to create unbound recordsets. After I've created a connection object (such as gcnADO_Or, below) I do something like the following (with declarations not shown here):

   Set mmySet = New ADODB.Recordset
   strSQL = "SELECT * FROM " & mstrmyTable & " ORDER BY " & mstrmyOrderby & " DESC"
   mmySet.Open strSQL, gcnADO_Or, adOpenForwardOnly, adLockReadOnly Then I stuff the grid object from the recordset.

Now VideoSoft's FlexGrid has an OLEDB version that loads the grid directly, but you work unbound thereafter. It seems to work fine in Visual Basic 6. Unfortunately, I can't use it in Access 97 because it doesn't expose all of its events properly there. So I use VideoSoft's UNBOUND version, using exactly the method shown above.

HTH >>>>>> Robert

hmueller <holger.mueller_at_meta-level.de> wrote in message news:387B8002.741B3CC2_at_meta-level.de...
> Hi!
> As I found out, a grid control (like the Microsoft DataGrid 6.0) can't
> be bound to a recordset created by a server-side cursor with the MSDAORA
>
> provider, cause the server-side cursor doesn't support bookmarks.
> The client-side cursor supports bookmarks and the grid control can be
> bound to its recorset. What's annoying, the client-side cursor seems to
> download the whole result from a query (which can last minutes for an
> amount of about 80000 sentences in my example).
>
> Is there a possibility for the client-side cursor to fetch only the
> necessary amout of data (for example only the first sentences to be
> shown in the grid) like the server-side cursor does?
>
> Or is there a setting for the server-side cursor to support bookmarks
> with the MSDAORA provider for Oracle?
> thanks a lot
> Holger
>
>
>
Received on Tue Jan 11 2000 - 14:05:16 CST