Subject Re: Record Locking
Author Alexander V.Nevsky
> >> 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).

If someone want entirely emulate MSSQL behaviour and lock records
for both _read_ and write, he should use read_commited no_rec_version
isolation level in addition to write locking. Good luck ;)

Best regards,