开发者

Is it possible to update one Firebird database from a trigger in another Firebird database?

开发者 https://www.devze.com 2023-01-01 02:01 出处:网络
I have two firebird databases running on the same server and I want to write to a table on one of the databases from a trigger on the other database when certain actions occur. I have had a searc开发者

I have two firebird databases running on the same server and I want to write to a table on one of the databases from a trigger on the other database when certain actions occur. I have had a searc开发者_Go百科h and cannot find out if this is possible.

Can it be done either natively in firebird or via a UDF?

Thanks

Neil


It will be possible in Firebird 2.5 using the "on external" syntax. Example:

EXECUTE STATEMENT('insert into table(field) values(?)')(:Param)
ON EXTERNAL 'another_server:C:\DB\DB.FDB'
AS USER 'SYSDBA' PASSWORD 'masterkey';
0

精彩评论

暂无评论...
验证码 换一张
取 消