- Jun 6, 2020
- 11,559
- 4,422
The Firebird Sql database has a feature that allows the db server to communicate with the clients that have subscribed to the desired events.
It is necessary to create a trigger like:
------------------------------------------
CREATE OR ALTER TRIGGER TR2 FOR PRODUCTS
ACTIVE AFTER UPDATE POSITION 0 AS BEGIN
IF (new.PRICE <> old.PRICE) THEN POST_EVENT 'price_changed';
END
------------------------------------------
Firebird ADO.NET Data Provider. Contribute to cincuranet/FirebirdSql.Data.FirebirdClient development by creating an account on GitHub.
This feature is very useful in applications such as chat or similar where the client part must react quickly to changes that occur in the database
It would be very interesting to have this functionality also for B4X programs, and therefore the question is:
how to 'subscribe' a Firebird...
It is necessary to create a trigger like:
------------------------------------------
CREATE OR ALTER TRIGGER TR2 FOR PRODUCTS
ACTIVE AFTER UPDATE POSITION 0 AS BEGIN
IF (new.PRICE <> old.PRICE) THEN POST_EVENT 'price_changed';
END
------------------------------------------
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن تصاویر باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید
Firebird ADO.NET Data Provider. Contribute to cincuranet/FirebirdSql.Data.FirebirdClient development by creating an account on GitHub.
برای دیدن تصاویر باید ثبت نام کنید
github.comThis feature is very useful in applications such as chat or similar where the client part must react quickly to changes that occur in the database
It would be very interesting to have this functionality also for B4X programs, and therefore the question is:
how to 'subscribe' a Firebird...
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید