Breaking out of RecordLock...

[Ruslan Zasukhin]

on 2/18/04 6:10 PM, Ken Ray at kray at sonsothunder.com wrote:

>> The way I understand what you describe will indeed leave a cursor
>> open until the program owning that cursor quits. But this should
>> happen only in a local mode. In server mode, the server should close
>> cursors when client disconnects AFAIK. I believe that this is what
>> Ruslan means "cannot be". If this does happen, Ruslan has to go bug
>> hunting.
> 
> No, Ruslan's right... it *does* close when the client disconnects, but
> since we don't know which client left the cursor open, everyone on the
> network needs to exit our program and disconnect from the server. This
> is something I was hoping to avoid if possible, because it is a terrible
> inconvenience to our customers.

Ken,

Does cursors select many records?
As you know RULE is cursor should make selection as small as possible.

May be you need make cursors that just browse table as NoLock?


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