General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only