Dynamic application data refreshing
I tried to find information in the lists but got no luck.
I want to make a client application that performs a query to show the
results, but the client application stays open and the database gets
updated.
I want that the updates of the database reflects on the open client
application, I think this can be done with triggers but I'm not sure how
to do this if there are 3 (or more) client applications open at the same
time, how the trigger can send a refresh to the 3 (or more) of them.
Can anybody help me????
I want to make a client application that performs a query to show the
results, but the client application stays open and the database gets
updated.I want that the updates of the database reflects on the open client
application, I think this can be done with triggers but I'm not sure how
to do this if there are 3 (or more) client applications open at the same
time, how the trigger can send a refresh to the 3 (or more) of them.
I'm not familiar with the following SQL statements, but I think these
could be useful:
LISTEN and NOTIFY.
Papp Gyozo
s7461pap@hszk.bme.hu, gerzson17@freemail.hu