Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Arkansas
    Posts
    15

    Unanswered: if update(@FieldName)

    Is there a way to use the if update(@variable)? It looks to me like you have to specify a column name @ design time.

    Is there any one out there that has a tight Audit Trail scheme where you do not have to hard code the column names. I want to log RecordID, NewVal, OldVal, User, dateTime.

    Thanks
    LJ
    Hope is the feeling that the feeling that you have will not last very long.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Dob't over think it...

    I have a history table for every table in my db's...

    on any update or delete, I move to old row to the history table via a trigger...

    I just add three additional columns to the history table to track when it was moved, by whom, and what action caused the move.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2003
    Location
    Arkansas
    Posts
    15
    Originally posted by Brett Kaiser
    Dob't over think it...

    I have a history table for every table in my db's...

    on any update or delete, I move to old row to the history table via a trigger...

    I just add three additional columns to the history table to track when it was moved, by whom, and what action caused the move.
    I was trying to Log all the changes to 1 Audit Table. We do this with Oracle and I was hoping to port of allot of application code for this SQL Server application.

    I was hoping to find a solution in the trigger rather than rewrite the app.

    Thanks for the suggestion, but I still need to find the answer.

    LJ
    Hope is the feeling that the feeling that you have will not last very long.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why don't you post what you have now that you want to port?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Oct 2003
    Location
    Arkansas
    Posts
    15
    Post the VB application that accesses the existing Oracle Audit table?

    The Table structure is the same and I will use ADO to connect so the application code will not change (very little if any).

    Thanks
    LJ
    Hope is the feeling that the feeling that you have will not last very long.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •