>Hello,

>i'm writing a client server application where DB would reside on Server
>side.
>For achieving this i use MySQL 3.23 and Delphi 5.For accessing MySQL data i
>use the Zeoss components set.

>The problem i've is record locking.I need to disable other ppl beginning
>changing the record if someone is alerady doing it(they can read it of
>course)
> How can i achieve record locking(preferably with Zeoss component set) is
>there a query for it, like: LOCK WHERE ....

>Thank you in advance,
>Gregor Doltar

> Hello,

> i'm writing a client server application where DB would reside on
Server
> side.
> For achieving this i use MySQL 3.23 and Delphi 5.For accessing MySQL
data i
> use the Zeoss components set.

> The problem i've is record locking.I need to disable other ppl
beginning
> changing the record if someone is alerady doing it(they can read it
of
> course)
>  How can i achieve record locking(preferably with Zeoss component
set) is
> there a query for it, like: LOCK WHERE ....

> Thank you in advance,
> Gregor Doltar

> are you using live results or caching?