[V4RB] Locked record problem

[Ruslan Zasukhin]

on 7/6/03 22:29, jda at jda at his.com wrote:

>> how do you know that only unlocked records are needed?
>> 
>> without NoLocks you just can't afford to have more than 1 cursor around
>> if you plan to edit your records at some time
>> 
>> you'll have to take the data, put them somewhere and kill the cursor
>> immediately
>> 
>> I don't like that!
>> 
> 
> Hi erne,
> 
> 
> 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?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------