Re: Effects on RST in Calling Proc

David W. Fenton wrote:
rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:KcrSe.54251$EX.21809@xxxxxxxxxxxxxxxxxxxx:


David W. Fenton wrote:

My rule: Never depend on bookmarks for anything where you can use
actual data to do so. Use bookmarks only for circumstances where
you *can't* use data.

What could possibly cause just the bookmark property to fail in a recordset opened as a snapshot?


You're asking the wrong question. I don't know that there are any
such conditions that lead to failure, but I don't know that there
are not. What I do know is that navigating by PK will *never* fail
if the recordset itself remains valid.

Why use something that is a black box about which I know very little
when there's a guaranteed method that doesn't have any blackbox
aspects to it? 

I don't see why you view the FindFirst method as any less of a
blackbox. The bookmark property is available for the exact purpose
of flagging and returning to a specific record in a recordset.
Saying that you can do the same in a more round about way doesn't
make it mysterious or unreliable.


.

Relevant Pages

  • Re: Zeilen im Datagrid bewegen
    ... Was kannst Du wie beim DG zur Entwurfszeit mit dem ADODC bearbeiten? ... > datagrid.rebind die bookmarks wieder löscht. ... Datensatz machen. ... solange das Recordset nicht neu geladen wird. ...
    (microsoft.public.de.vb)
  • Re: Bookmark 3159 nach Update
    ... Es machen wohl die von Access automatisch ... eingestellten Bookmarks Probleme. ... Es geht um ein Treeview, das mit Daten aus Recordset rs_show beliefert ...
    (microsoft.public.de.access)
  • one column listbox, multiple bookmarks, spreadsheet link
    ... spreadsheet using the MVP method from "Load a ListBox from a Named ... different bookmarks on the document should be filled out. ... ' Set the number of Columns = number of Fields in recordset ...
    (microsoft.public.word.vba.userforms)
  • 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)
  • Re: me.undo
    ... > First of all, thanks for explaining Recordset Clone and Bookmarks to me, ... >> Wayne Morgan ... >> MS Access MVP ...
    (microsoft.public.access.modulesdaovba)