Re: Trigger Question

Arthur,
  ... or you could try to use snapshots

  Which is a DB feature which does what you    are trying to accomplish.

Regards
Dante
In article <3732202e.265825_at_news.chaven.com>,   amerar_at_unsu.com (Arthur Merar) wrote:
>
> Hello,
>
> Are you good at Triggers? Here is my situation:
>
> I have two tables (T1 & T2) in a distributed network environment.
> When a record is inserted into T1, then a trigger will fire off and
> insert that same record into T2, which is located on a different
> server belonging to a different department.
>
> Now, they want this to be a one way communication only. We are not to
> query from then, only insert into their table.
>
> I need to know the result of the insert statement. If it is success
> or fails, I need to update a status field on my table (T1). However,
> I've been told that when a trigger fires off, the commit occurs AFTER
> the trigger is complete.
>
> If this is true, how will I know whether or not the commit was
> successful? Also, how will I ever find the record I just inserted?
>
> Can someone help?
>
> Thanks, please e-mail response.
>
> Arthur
> amerar_at_unsu.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 05:10:40 CDT