New Posts New Posts RSS Feed: Creating an audit record
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Creating an audit record
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
BillG View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 05-Dec-2007
Location: Monroe, MI
Posts: 233 		Post Options Post Options   Quote BillG Quote  Post ReplyReply Direct Link To This Post Topic: Creating an audit record
    Posted: 20-May-2009 at 10:36am

before saving the record, I would like to save the old values to an audit table.  The audit table contains all the fields that are in the main table plus some additional fields like date and user name.  What is the best way to take all the fields from the main record and insert a new record into the audit table along with the two additional fields.

 
Bill
 
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 20-May-2009 at 2:50pm
There are two excellent advanced tutorials on auditing.  One called "Abstract Classes" amd another called "Keeping an Audit Trail".
Back to Top
captaincrunch View Drop Down
Newbie
Newbie
Avatar

Joined: 14-Jun-2009
Location: Australia
Posts: 1 		Post Options Post Options   Quote captaincrunch Quote  Post ReplyReply Direct Link To This Post Posted: 14-Jun-2009 at 7:42pm
Do these tutorials apply to the WINCLIENT edition?
If not, where can I find information about keeping audit trails in that environment?

Would it be possible as a general rule to post a link to tutorials rather than just mention the name? With all the different devforce products scattered as they are, its difficult to find them, and even hard to know if they apply to your situation.
Back to Top
GregD View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 374 		Post Options Post Options   Quote GregD Quote  Post ReplyReply Direct Link To This Post Posted: 16-Jun-2009 at 5:01pm
Crunch, this is the DevForce Classic forum. Nothing here applies to DevForce WinClient.
Back to Top
f3rland View Drop Down
Newbie
Newbie
Avatar

Joined: 13-Sep-2007
Location: Canada
Posts: 25 		Post Options Post Options   Quote f3rland Quote  Post ReplyReply Direct Link To This Post Posted: 17-Jun-2009 at 12:46pm
Can you please provide links for classic version about :
"Abstract Classes" and "Keeping an Audit Trail"

Thanks
F3
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 18-Jun-2009 at 10:11am

As I believe that you are an existing Classic customer, you should be able to go to a machine that has Classic installed and get these Advanced Tutorials from that machine.  If that is not the case, send an email to support@ideablade.com
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down