Re: Effects on RST in Calling Proc
- From: "David W. Fenton" <dXXXfenton@xxxxxxxxxxxxxxxx>
- Date: Sat, 03 Sep 2005 23:06:09 -0500
rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:KcrSe.54251$EX.21809@xxxxxxxxxxxxxxxxxxxx:
> 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?
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?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.
- Follow-Ups:
- Re: Effects on RST in Calling Proc
- From: rkc
- Re: Effects on RST in Calling Proc
- References:
- Effects on RST in Calling Proc
- From: Tim Marshall
- Re: Effects on RST in Calling Proc
- From: rkc
- Re: Effects on RST in Calling Proc
- From: David W. Fenton
- Re: Effects on RST in Calling Proc
- From: rkc
- Effects on RST in Calling Proc
- Prev by Date: Re: Outlook mailitem
- Next by Date: Re: Does ACCESS have the MINUS keyword
- Previous by thread: Re: Effects on RST in Calling Proc
- Next by thread: Re: Effects on RST in Calling Proc
- Index(es):
Relevant Pages
|
