I am integrating Servoy with non-servoy application that will be creating records in mysql. I want to fire onRecordInsert() whenever that application inserts a new record.
Will onRecordInsert() fire if another application (non-servoy) is accessing the same database and inserts a new record, or do I have to write a database-level trigger?
Servoy is unaware of records that are inserted from “the outside”, onRecordInsert is therefore not triggered when you insert records from another application.
If you want to run a Servoy method from the outside, the headless client might be a good option.
When inserting records from the outside, also be careful not to use Servoy sequences in the tables you insert in, because the sequence will not be updated for the same reason.