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.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte