Martin,

> 1. Firebird can lock records either by api calls or some other method

Yes. One way is to do a dummy update (update mytable set myfield=myfield
where ...).

> 2. If it can point me to a website where there is information and or
> examples of record locking.

You should learn about transactions in Firebird. You don't lock a record,
you use a transaction mode that can give you this. But maybe you don't need
to do a lock at all. :-)

Get some info here: http://www.ibphoenix.com

Artur