Re: Setting DBPROP_BOOKMARKS Property- Help!!!!!


But when the TADODataSet is attached to an Orpheus DBTable component, even
when CursorLocation is clUseClient, CursorType always changes to clStatic
when I open the query or stored procedure. This prevents me from moving
backwards and forwards in the DBTable component, and I need b-directional
functionality. Help !!!

Clientside cursors are always bidirectional. So you are doing something that is
preventing you from getting a client side cursor.
Try a query with a TadoDataset where you set the commandtext and then Connection
but leave all other properties in their default value.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Current Recordset does not support updating.
    ... When the query is first opened all settings ... >> Current Recordset does not support updating. ... >> above CursorLocation to see if problem went away, ... I changed the CursorType to adOpenKeyset. ...
    (microsoft.public.vb.database.ado)
  • ADO query returning large dataset very slow
    ... I have to do some calculations on a very large dataset. ... The Query is setup like this: ... CursorLocation: clUseClient ... better component than the standard delphi ones. ...
    (borland.public.delphi.database.ado)
  • Re: ADO query returning large dataset very slow
    ... >I have to do some calculations on a very large dataset. ... >The Query is setup like this: ... >CursorLocation: clUseClient ... Normally you don't try to keep that many values in memory when you already have ...
    (borland.public.delphi.database.ado)
  • Bi-Directional Cursors in ADO - URGENT HELP NEEDED !!
    ... When a TADODataSet is attached to an Orpheus DBTable component, ... when CursorLocation is clUseClient, ... when I open the query or stored procedure. ...
    (borland.public.delphi.database.ado)