>I was reading the Interbase Docs about TRANSACTION and I have two question

>1.- How can I Start a Named Transaction. Is there a ·"Begin Transaction"
>instruction?ç

If you use isql, you can't start a named transaction. It only work at static
sql only (Helen & Ann tell me about that few days ago). Then, the command to
start the transaction is 'SET TRANSACTION'. You must read the transaction
general syntax first.

>2.- Can I lock a single field like SQL Server for example:

>In SQL Server:

>SELECT P.CONCOD, C.CODALT, C.TPOCON, C.TPOCAL, P.IMPORT
> FROM PERCON P (nolock), CONCEPTOS C (nolock)
> WHERE P.CONCOD = C.CONCOD

I never use SQL server before, but with your example above, tou talk about
table locking, not field locking (correct me if I'm wrong). If yes, Firebird
can do that with 'table reservation'. With that method you can make a list
of tables and you can control the method like SHARED WRITE, SHARED READ,
PROTECTED READ, PROTECTED WRITE. Read Claudio valderama paper, it's good for
understanding transaction. Firebird / Interbase was known as RDBMS with hot
transaction handling. :)

Regards,
Agung w www.firebird-indonesia.net