ASPRunner Professional 7.0 manual - Events. Save old data in another table

To save old data in another table use Save old data record in another table action.

Available in following events:

·	Edit page: Before record updated;

·	List page: Before record deleted.

step11-1-9

Note: Change the values listed in red to match your specific needs.

'********** Save old data record in another table ************

dim rsFields

set dal_table=dal.Table(strTableName)

set rsFields = dal_table.Query(where,"")

if not rsFields.eof then

set dal_table_another=dal.Table("AnotherTable")

dal_table_another.Field1=rsFields("Field1")

dal_table_another.Field2=rsFields("Field2")

dal_table_another.Add()

end if

rsFields.close: set rsFielgs=nothing

For more information about using Data Access Layer (DAL), see Data Access Layer.