Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What table fired this trigger?

2 posts in Trigger Last posting was on 2005-03-16 13:15:40.0Z
GAL Posted on 2005-03-16 12:52:26.0Z
From: "GAL" <guenteralthof@t-online.de>
Newsgroups: advantage.trigger
Subject: What table fired this trigger?
Date: Wed, 16 Mar 2005 13:52:26 +0100
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.7.40.34
Message-ID: <42382ce9@solutions.advantagedatabase.com>
X-Trace: 16 Mar 2005 05:56:09 -0700, 213.7.40.34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.7.40.34
Xref: solutions.advantagedatabase.com Advantage.Trigger:156
Article PK: 1136224

I created an audit-trigger as dll with a lot of tables sharing this trigger.
How can I find out the tablename of that table what fired that trigger:
oNew.SQL.Text := 'SELECT * FROM __new';
I wanted to get the name of __new.

Tnx GAL


GAL Posted on 2005-03-16 13:15:40.0Z
From: "GAL" <guenteralthof@t-online.de>
Newsgroups: advantage.trigger
References: <42382ce9@solutions.advantagedatabase.com>
Subject: Re: What table fired this trigger?
Date: Wed, 16 Mar 2005 14:15:40 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.7.35.106
Message-ID: <4238325f@solutions.advantagedatabase.com>
X-Trace: 16 Mar 2005 06:19:27 -0700, 213.7.35.106
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.7.35.106
Xref: solutions.advantagedatabase.com Advantage.Trigger:157
Article PK: 1136222

Sorry for that posting.
I should have looked to the functionheader, where I could find it now.

tnx GAL

"GAL" <guenteralthof@t-online.de> schrieb im Newsbeitrag
news:42382ce9@solutions.advantagedatabase.com...

>I created an audit-trigger as dll with a lot of tables sharing this
>trigger. How can I find out the tablename of that table what fired that
>trigger:
> oNew.SQL.Text := 'SELECT * FROM __new';
> I wanted to get the name of __new.
>
> Tnx GAL
>