2. ASPRunnerPro General questions
  3. change delete to add stopdate
This topic is locked

change delete to add stopdate

 		6/9/2009 2:45:18 PM
ASPRunnerPro General questions
T
 tone21705 author

Hi,
ASPRunner 6.0 Build 776
I have a table with 3 columns: Id, StopDate, and ObjectName
When I click Delete in ASPRunner I want it to add the date to the StopDate column instead of deleting the whole record. How would I do this? I looked into Events, but am unsure.
Thanks in advance and great program!
J
 		Jane 6/10/2009

Hi,
checkBefore record deleted event on the Events tab.

Here is a sample:

str = "update tablename set stopdate=now() where " & where

dbConnection.Execute str
BeforeDelete=False