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.

Instead of Insert issue

2 posts in Trigger Last posting was on 2007-12-12 22:34:29.0Z
CR Posted on 2007-12-12 18:32:45.0Z
From: "CR" <vevici@gmail.com>
Newsgroups: Advantage.Trigger
Subject: Instead of Insert issue
Date: Wed, 12 Dec 2007 11:32:45 -0700
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 69.92.221.51
Message-ID: <4760280c@solutions.advantagedatabase.com>
X-Trace: 12 Dec 2007 11:27:24 -0700, 69.92.221.51
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.92.221.51
Xref: solutions.advantagedatabase.com Advantage.Trigger:362
Article PK: 1136422

I have an INSTEAD OF INSERT triger on my "eventdetails" table ... it does
other things, but at the end, this INSERT performs the final act. But the
last two fields show up as null when I view the resulting record. How do I
troubleshoot this?

Carl

insert into eventdetails
(
pgkEventId,
webContactId, webVinId,
resourceid, subject,
startdate, starttime, startdatetime,
enddate, endtime, enddatetime,
fkSvcStatus, createdby, createdon,
readonly, visible,
fkrep, createdts, changedts,
fkstore, fkcreator, fkchanger,
fkContact,Location
)
select
pgkEventId,
webContactId, webVinId,
resourceid, subject,
startdate, starttime, startdatetime,
enddate, endtime, enddatetime,
fkSvcStatus, createdby, createdon,
readonly, visible,
fkrep, createdts, changedts,
fkstore, fkcreator, fkchanger,
-1, 'junk'
from __new;


/* END */


Edgar Sherman Posted on 2007-12-12 22:34:29.0Z
From: "Edgar Sherman" <no@email.com>
Newsgroups: Advantage.Trigger
References: <4760280c@solutions.advantagedatabase.com>
Subject: Re: Instead of Insert issue
Date: Wed, 12 Dec 2007 15:34:29 -0700
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: 10.24.34.133
Message-ID: <476060b2@solutions.advantagedatabase.com>
X-Trace: 12 Dec 2007 15:29:06 -0700, 10.24.34.133
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.133
Xref: solutions.advantagedatabase.com Advantage.Trigger:363
Article PK: 1136424

Carl,

Did you log out and back into the Data Dictionary after creating the
trigger? If I remember correctly the trigger will not activate until the
table is closed and re-opened on the server. This sounds like the behavior
you are probably seeing.

Edgar

"CR" <vevici@gmail.com> wrote in message
news:4760280c@solutions.advantagedatabase.com...
> I have an INSTEAD OF INSERT triger on my "eventdetails" table ... it does
> other things, but at the end, this INSERT performs the final act. But the
> last two fields show up as null when I view the resulting record. How do
> I troubleshoot this?
>
> Carl
>
> insert into eventdetails
> (
> pgkEventId,
> webContactId, webVinId,
> resourceid, subject,
> startdate, starttime, startdatetime,
> enddate, endtime, enddatetime,
> fkSvcStatus, createdby, createdon,
> readonly, visible,
> fkrep, createdts, changedts,
> fkstore, fkcreator, fkchanger,
> fkContact,Location
> )
> select
> pgkEventId,
> webContactId, webVinId,
> resourceid, subject,
> startdate, starttime, startdatetime,
> enddate, endtime, enddatetime,
> fkSvcStatus, createdby, createdon,
> readonly, visible,
> fkrep, createdts, changedts,
> fkstore, fkcreator, fkchanger,
> -1, 'junk'
> from __new;
>
>
> /* END */
>
>
>