Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Location
    Prague, Czech Republic
    Posts
    8

    Unanswered: Trigger - copy before delete record

    Hello,

    I am looking for trigger which will copy a record to another database before erasing (I am confused about reference to another database inside trigger).

    Can someone help me?

    Thank you in advance

    Jan

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    At this point of time(or atleast the last time I read the manuals!) you cannot use triggers to update a remote database table.
    The alternative is to insert the deleted record into a local table and copy the records to the remote database table on a periodic basis, say, by means of a script or Replication.
    HTH
    Sathyaram

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •