Re: Effects on RST in Calling Proc



rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:zCBSe.54285$EX.9212@xxxxxxxxxxxxxxxxxxxx:

> 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.

But we know that a bookmark is volatile data, while the primary key
is *not* volatile.

FindFirst is a method, whereas a bookmark is a form of data. I'm
advocating the use of reliable data for your navigation, and the
volatility of a bookmark makes me wary of using it except when it
can't possibly have been invalidated (i.e., immediately after a
Findfirst).

I am suspicious of any code that stores a bookmark value, as there
should always be a better method of getting back to the same record
using real data, rather than metadata about the recordset.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.


Quantcast