Reputation: 15
Is it possible to generate a trigger to send an email every time a record is inserted into a table? I am using Firebird 2.5.
Upvotes: 0
Views: 217
Reputation: 109138
Firebird itself doesn't provide anything for sending email out of the box. In Firebird 2.5, you can write a custom UDF (User-Defined Function) that allows you to send email. In Firebird 3.0 and higher you can also write a UDR (User-Defined Routine; the replacement for UDF).
For an alternative solution, see also How to create a trigger to send email.
Upvotes: 3