NoLocks // 1.9.8b10 adoption of record locks. Feedback

[Ruslan Zasukhin]

on 7/6/03 19:57, erne at ernestogiannotta at tiscalinet.it wrote:

> I see, but still don't understand how could we do this ourselves if
> needed
> e.g.
> imagine a multiuser client/server schedule app
> € user A is browsing his list of todo on his client
> (the list was built creating a readonly cursor from the server's
> database and copying the result in some local list)
> € user B adds a todo item via his client, now the user A has an
> outdated list

But may be user want STABLE selection that is NOT affected by user B.
And usually this is what he want.

In Fact user A must NOT see records added by other users.

> how does the system know that user A's list must be updated?
> 
> mmm... well I guess I need a server side module app doing this job for
> me communicating via sockets...
> 
> I was stuck in the idea to have for free network-ready apps
> and Miss Vale's kernel do the whole handling...
> 
> still it would be a nice idea
> (and a way better coded job ;-)

Erne,

First of all I recommend to find and read some book about RDBMS and
transactions. About Isolation levels 0 - 3.

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