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 & COM Component and ulRecNo variable

3 posts in Trigger Last posting was on 2004-07-27 04:27:05.0Z
Bernie Brondum Posted on 2004-07-15 05:11:40.0Z
From: "Bernie Brondum" <bernicusmaximus@comcast.net>
Newsgroups: advantage.trigger
Subject: Trigger & COM Component and ulRecNo variable
Date: Thu, 15 Jul 2004 00:11:40 -0500
Lines: 12
Organization: AppMill
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
NNTP-Posting-Host: 24.245.40.209
Message-ID: <40f61404@solutions.advantagedatabase.com>
X-Trace: 14 Jul 2004 23:20:04 -0700, 24.245.40.209
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.245.40.209
Xref: solutions.advantagedatabase.com Advantage.Trigger:83
Article PK: 1136148

I have sucessfully created a trigger using a COM component, but I am at a
loss as to how to associate the triggered event with the record that has
just changed. I imagine that I could use a temporary table and SQL trigger
in concert with the COM trigger, but it seems like more work than necessary.
Thought someone might have a better idea. Any advice is appreciated.

Thanks,

Bernie


Jeremy D. Mullin Posted on 2004-07-26 14:01:29.0Z
From: Jeremy D. Mullin <no@email.com>
Newsgroups: advantage.trigger
Subject: Re: Trigger & COM Component and ulRecNo variable
Date: Mon, 26 Jul 2004 08:01:29 -0600
Message-ID: <MPG.1b6ebca692a38182989d05@solutions.advantagedatabase.com>
References: <40f61404@solutions.advantagedatabase.com>
Organization: ESI
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: 198.102.102.187
X-Trace: 26 Jul 2004 08:11:10 -0700, 198.102.102.187
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.187
Xref: solutions.advantagedatabase.com Advantage.Trigger:93
Article PK: 1136159

The record that has just changed is in the __old table. See the
documentation.

J.D. Mullin
Advantage R&D

In article <40f61404@solutions.advantagedatabase.com>,
bernicusmaximus@comcast.net says...

> I have sucessfully created a trigger using a COM component, but I am at a
> loss as to how to associate the triggered event with the record that has
> just changed. I imagine that I could use a temporary table and SQL trigger
> in concert with the COM trigger, but it seems like more work than necessary.
> Thought someone might have a better idea. Any advice is appreciated.
>
> Thanks,
>
> Bernie
>
>
>
>


Bernie Brondum Posted on 2004-07-27 04:27:05.0Z
From: "Bernie Brondum" <bernicusmaximus@comcast.net>
Newsgroups: advantage.trigger
References: <40f61404@solutions.advantagedatabase.com> <MPG.1b6ebca692a38182989d05@solutions.advantagedatabase.com>
Subject: Re: Trigger & COM Component and ulRecNo variable
Date: Mon, 26 Jul 2004 23:27:05 -0500
Lines: 35
Organization: AppMill
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
NNTP-Posting-Host: 24.245.40.209
Message-ID: <4105dbbf@solutions.advantagedatabase.com>
X-Trace: 26 Jul 2004 22:36:15 -0700, 24.245.40.209
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.245.40.209
Xref: solutions.advantagedatabase.com Advantage.Trigger:95
Article PK: 1136161

J.D.,

I did run across that in documentation a day or so after my post. Thanks
for the tip.

Bernie

"Jeremy D. Mullin" <no@email.com> wrote in message
news:MPG.1b6ebca692a38182989d05@solutions.advantagedatabase.com...
> The record that has just changed is in the __old table. See the
> documentation.
>
> J.D. Mullin
> Advantage R&D
>
> In article <40f61404@solutions.advantagedatabase.com>,
> bernicusmaximus@comcast.net says...
> > I have sucessfully created a trigger using a COM component, but I am at
a
> > loss as to how to associate the triggered event with the record that has
> > just changed. I imagine that I could use a temporary table and SQL
trigger
> > in concert with the COM trigger, but it seems like more work than
necessary.
> > Thought someone might have a better idea. Any advice is appreciated.
> >
> > Thanks,
> >
> > Bernie
> >
> >
> >
> >