Thread: 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