Subject | [firebird-support]using parameters with EVENT firebird 2.5+ |
---|---|
Author | Rustam |
Post date | 2019-09-20T10:16:18Z |
I am also looking for somthing like that. Typical task - inform clients about changes in some records: client need an record ID.
It's hardly compatible with the existing events architecture and API, so
I'm still somewhat sceptical about its implementation.
Dmitry
I don't now API details, but my idea: what if we can specify 'mask' in Event name on clients, e.g. "ORDER_CHANGED*"?
Then client subscribes to event "ORDER_CHANGED*", and his code receive all events, who name is starting with "ORDER_CHANGED".
On DB side in trigger we can fire event like that:
post_event('ORDER_CHANGED' || new.ID)
In client's code he get an actual event name, like ' ORDER_CHANGED9999'. Then he can parse received string as he need.