Events. Save old data in another table

Save old data in another table action allows saving the old data in another table when the record is updated or deleted. This table should be a part of the project.

Available in following events:

•Edit page: Before record updated

•List page: Before record deleted

Example 1. Direct SQL query

'**********  Save the old data record in another table  ************
Dim data
Set data = CreateDictionary()
data("make") = oldvalues("make")
data("model") = oldvalues("model")
data("price") = oldvalues("price")
DB_Insert "copy_of_cars",data

See also:

•Database API

•Database API: Insert        

•Save new data in another table

•Insert a record into another table