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.

Trigger After a Trigger

3 posts in Trigger Last posting was on 2006-08-03 14:44:31.0Z
Brent Nelson Posted on 2006-08-01 21:55:42.0Z
Date: Tue, 01 Aug 2006 15:55:42 -0600
From: Brent Nelson <bnelson@westernwats.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Trigger After a Trigger
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.20.254.254
Message-ID: <44cfccfb@solutions.advantagedatabase.com>
X-Trace: 1 Aug 2006 15:51:55 -0700, 216.20.254.254
Lines: 6
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.20.254.254
Xref: solutions.advantagedatabase.com Advantage.Trigger:267
Article PK: 1136332

Is it possible to fire an AFTER INSERT trigger on a table that is having
records updated by another trigger on another table? I have yet to get
it to work. I am trying to remove duplicate records and other records
with invalid data PLUS I am trying to update a count of the duplicate
records (so there would exist one record with a count of how many dups
there were before I delete them).


Brent Nelson Posted on 2006-08-02 16:11:58.0Z
Date: Wed, 02 Aug 2006 10:11:58 -0600
From: Brent Nelson <bnelson@westernwats.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: Trigger After a Trigger
References: <44cfccfb@solutions.advantagedatabase.com>
In-Reply-To: <44cfccfb@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.20.254.254
Message-ID: <44d0cdeb@solutions.advantagedatabase.com>
X-Trace: 2 Aug 2006 10:08:11 -0700, 216.20.254.254
Lines: 10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.20.254.254
Xref: solutions.advantagedatabase.com Advantage.Trigger:268
Article PK: 1136334

Nevermind, for some reason my trigger wasn't saving (activating) until I
opened its properties and saved them (weird).

Brent Nelson wrote:
> Is it possible to fire an AFTER INSERT trigger on a table that is having
> records updated by another trigger on another table? I have yet to get
> it to work. I am trying to remove duplicate records and other records
> with invalid data PLUS I am trying to update a count of the duplicate
> records (so there would exist one record with a count of how many dups
> there were before I delete them).


Jeremy Mullin Posted on 2006-08-03 14:44:31.0Z
Date: Thu, 3 Aug 2006 14:44:31 +0000 (UTC)
Message-ID: <886edc1516ed68c884f02c26cd01@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Trigger After a Trigger
Newsgroups: Advantage.Trigger
References: <44d0cdeb@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 928.2
NNTP-Posting-Host: 10.24.38.116
X-Trace: 3 Aug 2006 08:40:44 -0700, 10.24.38.116
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.116
Xref: solutions.advantagedatabase.com Advantage.Trigger:270
Article PK: 1136337

Keep in mind the trigger definitions are only updated/refreshed in the server
after all connections that have been using them are closed. If you had the
table opened in another browse window, for example, it would need to be closed
before your definitions would be refreshed. I'm hoping to change this behavior
(or at least adjust it) for the 9.0 release.

J.D. Mullin
Advantage R&D

> Nevermind, for some reason my trigger wasn't saving (activating) until
> I
> opened its properties and saved them (weird).
> Brent Nelson wrote:
>
>> Is it possible to fire an AFTER INSERT trigger on a table that is
>> having records updated by another trigger on another table? I have
>> yet to get it to work. I am trying to remove duplicate records and
>> other records with invalid data PLUS I am trying to update a count of
>> the duplicate records (so there would exist one record with a count
>> of how many dups there were before I delete them).
>>