I have two tables:
Table 1: MIS
userid (int)
name (varchar)
Table 2: history
userid (int)
name (varchar)
datedelete (datetime)
On delete the entry in the MIS table, the same entry is saved in history table. I want to save the deletion date in the history table. I used the following code but the datedelted saved the null values. what code should i use for this.
set dal_table=dal.Table("MIS")
dal_table.userid=delete_values("userid")
dal_table.name =delete_values("name")
dal_table.datedelete =delete_values("now()")
dal_table.Add()