Hi,

>Sorry again... My mistake!!!! ... It works fine... but how can I get the old values? .... I get "RODOLFO DUARTE", but how can I get the old value "RODOLFO"?

No buffering is involved so there is no OLDVAL(). If you need to retain the old values I think you'll need to do this in your application - perhaps by routing all your tableupdates() thru a common method. Your log file will also be a lot shorter since you can just record changed fields.

>I think I don't understand it correctly... You suggest me that I have one log table for each table in my database? ... If not, how would be the structure of this log table?

Just one DBF with fields for table name, field, newvalue, timestamp etc.

Regards,
Viv