Hi Alonso,

>I was thinking about something that i could tell the user exactlly what happened. Something like "Duplicated PK" (this i check before BEGIN TRANS), etc.
>
>So, i would issue a ROLLBACK knowing why i had to.

You could also use

nError=0
ON ERROR nError=ERROR()

IF nError = 0
   END TRANSACTION
ELSE
   ROLLBACK
ENDIF

DO CASE 
   CASE nError=0
        ... Transaction succesfull

   CASE nError=1
        .... Handle the error

   CASE nError=2
        .... Handle the error

   ...
ENDCASE

You can also use TABLEUPDATE( 2, lForce, Alias, cErrorArray) to check if a transaction is succesfull without using the error routine.

AERROR() is another function that you might find to be helpfull to determine the cause of the error.

Walter,