Locking a whole Database on Server

[Ruslan Zasukhin]

On 22/3/07 12:55 PM, "Stan Busk" <maxprog at mac.com> wrote:

Hi Stan,

> Is it possible to lock access to a whole database from Embedded
> Server? I just want to allow first client to connect, if some
> maintenance has to be performed lock access to all other clients
> until the maintenance is done. I have seen that a lot of time in 4D.
> I just need to be able to send a given error to all the other clients
> trying to connect so they can wait until the lock is released. I can
> then display a 'Maintenance on the way, please wait' dialog. Is it
> possible with Valentina Embedded Server?

No, but I think easy enough to implement, at least this EXCLUSIVE lock.
Please report it into Mantis.

May be the same can be done to TABLE level:

1) API:

   VDaatbase.Lock( kReadWrite )
   VTable.Lock( kReadWrite )


2) SQL

    "LOCK DATABASE db_name READWRITE"
    "LOCK TABLE tbl_name READWRITE"


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]