B
B
bernex2015-07-07 17:47:25
SQL
bernex, 2015-07-07 17:47:25

Is it possible to call an action to change a row in Firebird?

There is a database, is it possible to organize a "callback" (a request for a url with the ID of the changed record), a database when a line or status, date changes?
An internal solution would be ideal, or perhaps there are plugins, libraries or programs for this. Productive and fast and most importantly reliable.
Those. so that all its lines are not interrogated for change. Because many applications work with it. And it's hard to sync the data.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
V
Vadim, 2015-07-16
@bernex

There is such a thing as "Events". Firebird Event (alerts)
When any data in the table changes, an Alert is generated that is sent to all connected Clients. And then they reread the data.

S
Stalker_RED, 2015-07-07
@Stalker_RED

www.firebirdsql.org/refdocs/langrefupd15-create-tr...

L
ldv, 2015-07-07
@ldvldv

You can write your own UDF wm-help.net/lib/b/book/4054355128/487
Or use a trigger to add the row ID and table name to a special table, from where to read information every 15 seconds, for example.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question