2. ASPRunnerPro General questions
  3. Referring to key field in current table in events
This topic is locked

Referring to key field in current table in events

 		12/11/2006 14:38:59
ASPRunnerPro General questions
B
 berkeleyjw author

Since upgrading to 4.1, I am having problems when trying to use the current key field value in event code. Is it still "key", or is it a new session variable (similar to how the parent key is now)?
B
 		berkeleyjw author 12/11/2006

To clarify, I am using the List page, Before Record Deleted event. I can't just use the WHERE clause because I need to EXCULDE the current record from some additional code that affects another table. I guess I can use the NOT EXISTS clause instead, but I still need to know if there is a way to retrieve the current record's key value in this event. Thanks.
J
 		Jane 12/12/2006

Jim,
you can use the folowing code in the Before record deleted event:

keys("ID")

keys("ID2")



where ID, ID2 are your actual key fields.