Re: Effects on RST in Calling Proc

David W. Fenton wrote:
rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:f5pSe.75699$Hx4.20168@xxxxxxxxxxxxxxxxxxxx:


Whether or not the effects of move operations on the recordset in
the procedure it's passed to are reflected in the calling
procedure on return is easily tested so I assume your question is
does it make sense to open two recordsets. I'd say no. You can
always save your position before passing the recordset and return
to it after the call. I believe that is a legitimate/safe use of a
Bookmark. 


I wouldn't.

I'd save the PK of the record that's current when you pass the
recordset to called procedure, then when control returns do a
FindFirst on the PK.

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?



.

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)
Quantcast