Interbase Trigger across multi databases

John Hunter jthunter@nbnet.nb.ca
Wed, 2 Dec 1998 14:43:11 -0400


Hi Gang,

I have a need to perform a trigger action that updates from one Interbase
database to another upon a store to a table.  Has anyone achieved this? Is
it at all possible? I've tried using a procedure that readies the other
database, but get the error:  ** QLI error: relations from multiple
databases in single rse ** when executing. 

I'm currently using:
 Powerhouse 610.e
 InterBase/vms (access method), version "VM-V3.3D(3)"
 on disk structure version 7.2

We're on our way to Powerhouse 8.10b and Oracle...but have a need for the
above prior to that.

Thanks for any tips,
-John
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.