Hi,

At April 29, 2004, 08:56, Martijn Tonies wrote:

> Hi,

>> I am working with INDY components over the internet. Now one application
>> has to access the firebird database with multiple threads. Is it possible
>> to lock one record for a thread until the thread has finished reading and
>> writing to that record ? Is it also possible to lock a range of selected
>> record for instance child records of a master record for reading and
>> writing until my thread is finished ?

> Doing a dummy update on a record will "lock" it for
> other transactions.

> eg:

> UPDATE mytable SET ID = ID WHERE ID = :MyID

Or use the newly introduced WITH LOCK clause in FB 1.5(details in the
release notes).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)