Navneet Kakkar
|
Posted: 02/22/2004, 5:54 AM |
|
want to track the changes being made by users.
i want whenever a record is added or edited, the sql executed to be stored
into an seperate tracking table which has a structure as below.
id
user
sql
pagename
date
fromip
fromcomputername
Please advise is there any way i pass the above information to a
maintainence page for the tracking table and on load the same submits itself
to insert a record into the table with the above data.
also advise which is the variable in which the insert or update sql is
stored.
the sql datasource of the record has the sql for retrival of that record,
not for update and insert
--
Thanks
luv
Navneet
aquananu@yahoo.com
9811153443
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004
|
|
|
peterr
Posts: 5971
|
Posted: 02/22/2004, 1:04 PM |
|
You can create a function in Common.asp that you can call from "After Insert" and "After Update" events of your forms.
For example:
UpdateLog (FormName.Command.SQL & " " & FormName.Command.Where, Session("UserID"), .etc.)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
|
|
|