[V4RB] Locked record problem

[jda]

>
>  > Well, my problem is that I have to grab some records based upon their
>>  having a certain value in the 'hit' field, and then change the 'hit'
>>  field of *all the records that did not match* to 0. I could do a
>>  second query for all records that didn't have the requested 'hit'
>>  value, but (1) that's hard to code (my users enter the sql string
>>  themselves), and (2) was completely unnecessary before! Since my app
>>  is not a server-based product, I really don't need record locking
>>  (never did before) but now I've got to deal with it. I'd like a way
>>  to revert to the original behavior (which is what I thought NoLocks
>>  was intended for, but which does NOT work that way). Failing that,
>>  I'd like to be able to identify if a record is locked or not, and be
>>  able to select it based upon that property.
>
>
>Jon,
>
>I think RIGHT WAY is to fix NoLock for me.
>Agree?
>

Um, if you mean the right way is for *you* to fix NoLock for *me*, 
then yes, absolutely!!!!  :->

Jon