Subject Re: [firebird-support] How to INSERT from a TRIGGER into another database?
Author Milan Babuskov
rekkod wrote:
> I want to INSERT records within a trigger but into another database. I
> should be able to do this with a UDF, but I assume I will have to
> connect to the database in the UDF with each INSERT, which will take
> very long. Is there another way?

Write an external application to do it. To make it efficient you can use
events. The app. would connect both databases. In first it would wait
for event. Inside the trigger you fire the event, and the app. should
read the record and do the INSERT in other database.

Milan Babuskov