Hi Viv,

A) Insert Into Customer (Id, Name) Values (1, "RODOLFO")
This should work. Don't know why you're seeing .NULL.

Sorry, my mistake.... It works fine...

B) Update Customer Where Id = 1 Where Name = "RODOLFO DUARTE"
Syntax isn't valid but again 'Update Customer Set Name = "RODOLFO DUARTE" WHERE Id=1' works as expected for me.

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"?

Why not use a DBF with relevant fields - after all for an audit trail to be useful you'll need to be able to perform searches on it.

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?

Thanks for your attention.