Results 1 to 2 of 2

Thread: Sybase triggers

  1. #1
    Join Date
    Apr 2003
    Location
    London
    Posts
    2

    Unhappy Unanswered: Urgent: Sybase triggers

    I have some application code that runs transactions on my database - this then fires triggers that run audit information on secondary tables. I also have application code running on the audit tables.

    Does anyone know how I can then write a trigger on the secondary table that detects whether the insert is run from the trigger or the application? Is there a system table that can tell me this? I have tried sysprocesses, systransactions and syslogshold - no joy. Any ideas?
    Last edited by LEO_ARMER; 04-22-03 at 12:20.

  2. #2
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: Urgent: Sybase triggers

    You may need to add this into your database. I'm afraid details like this tend to drop out in development. It's part of why the logical and physical designs for the database can be different.

Posting Permissions

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