[Lazarus] Trigger cross database

Michael Van Canneyt michael at freepascal.org
Sun Jan 2 15:58:29 CET 2011



On Sun, 2 Jan 2011, allies_xposs at yahoo.com wrote:

> For all,
>
> I have 2 database with name DTBS1.fdb have table test  and DTBS2.fdb have table test. In DTBS1 and table test I'm want to create trigger after insert for insert to table test(DTBS2), can I ?

Not generally. This is not a FPC limitation, but a Firebird limitation.

What you can try to do is try to use Firebird 2.5, it has support for cross-database queries 
in stored procedure language.

Michael.




More information about the Lazarus mailing list