Re: ADODB.Recordset.Bookmark


"Richard M. Hartman" <hartman@xxxxxxxxxxxx> wrote in message
news:OgNB5YhMIHA.6100@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the info. I'm not really a beginner developer, just new to ADO
(been stuck using DAO for ever). I know about bookmarks _in_general_, but
can't seem to make 'em work for me with ADO.

I changed the cursor type to static, and bookmarks work, but now I can't
update the recordset. The first cursortype I tried (as I mentioned) was
dynamic (adOpenDynamic, to be precise). I'll look into the Supported()
function.


I apologize if I sounded patronizing. One is never sure and it is easier to
just cover all bases. <g>

Using a Recordset, are you sure you have an updateable one? The locktype is
the important factor as any cursor other than the default will work.

For anyone, no matter what their background I usually recommend two books:
The most complete:
"ADO: ActiveX Data Objects" by Jason T. Roff, O'Reilly
Pretty good:
"ADO Examples and Best Practices" by William R. Vaughn, Apress
It always helps to get a good over-all view. Most of these are available at
reduced prices.

Unless using Vista, it helps to make sure you have the latest 'n greatest
ADO library and Providers (MDAC):
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

-ralph








.

Relevant Pages

  • Re: ADODB RECORDSET Optimierung
    ... Recordset mit einem Static Cursor öffnest? ... Damit zwingst Du ADO die ganze Tabelle in den Speicher einzulesen und eine Kopie aller Records anzulegen. ...
    (microsoft.public.de.access.clientserver)
  • Re: ADO Data Control Concurrency Problem
    ... >> Editing of row in table is done with the help of ADO Data Control. ... Cursor location does not bare on whether the ... Client or Server memory. ... reflected in the open recordset. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADODB.Recordset.Bookmark
    ... Thanks for the info. I'm not really a beginner developer, just new to ADO ... I changed the cursor type to static, and bookmarks work, but now I can't ... property of the connection or recordset that can tell me whether the ...
    (microsoft.public.vb.database.ado)
  • Grids on form with Private Datasession and 3 tier application
    ... like to display a recordset in a grid on my form. ... am on the verge of just coding the data access straight into my grid control ... Is my best option ADO or another idea? ... will accept ADO as a recordset or do I have to convert it back to a cursor? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: get multivalued data from a Recordset
    ... can you get Recordset Open() if you try opening a table or issue ... 2i) I would try a Server-sided,Forward-Only,Read-only cursor first. ... CursorType and LockType AFTERWARDS to see what ADO _really_ returned. ...
    (microsoft.public.data.ado)