Contents

 
Home
ASPRunner Professional 7.1 manual
Prev Page Next Page
 
 

Store the date and time when a record is modified

 

To keep track of when records in a table are last modified or who made the modification you have two options:

1. Set default value under 'Edit as' settings.

To store login name of the user who made the change:

SESSION("UserID")

To store modification date and time:

Now()

Make sure to check off 'Apply on the Edit page as well' check box.

2. Add the following code to BeforeAdd/BeforeEdit events:

values("DateUpdated")=now()
values("UpdateBy")=SESSION("UserID")

 

 

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)