Results 1 to 2 of 2

Thread: Sybase triggers

  1. #1
    Join Date
    Apr 2003

    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 11:20.

  2. #2
    Join Date
    Sep 2002
    Hong Kong

    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