Logging Database Transactions

Posts   
 
    
Posts: 24
Joined: 19-Feb-2007
# Posted on: 20-Jun-2007 23:45:01   

Hi,

I have a Database table built that will hold information on any INSERT, UPDATE, DELETE that occurs in our program (information would include, user ID, IP address, form values, etc.). I was wondering if there was a place in LLBL code that I could tap into and write values of the associated INSERT/UPDATE/DELETE into the specific table. I am really trying to avoid having to save an entity on every page that one of those 3 commands occur (I was hoping there would be one centralized place that this could happen). I've seen similar topics and one of the solutions mentioned was .NET tracing, I was wondering if there were any other solutions you could recommend.

By the way, I'm using: Using version: 2.0.07.0122 Also using SQL Server 2000 Self-Servicing

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 21-Jun-2007 03:13:34   

Hi. Have you read this thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3612 ??

Also I've good news for you, in version 2.5 (http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=10170) just released, there is a fully transparent auditing.

David Elizondo | LLBLGen Support Team