rudyj
Posts: 6
|
Posted: 11/21/2013, 2:07 PM |
|
I want to be able to add a audit entry into a sql table. Basically I want to know when they view a record.
|
|
|
eratech
Posts: 513
|
Posted: 11/21/2013, 4:22 PM |
|
I usually put some logging in the After Update or After Insert, but that's for editing, obviously.
You can put some logging into the Before Show for the Record, to log the record id and user id.
Look in the Help for 'Execute Custom SQL' as it has a good example there that is almost exactly what you want (change code example to ASP)
E
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|