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

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com