Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: database update and charts



Permlink Replies: 4 - Last Post: Dec 6, 2015 12:30 AM Last Post By: Alan Jeffery Threads: [ Previous | Next ]
Edmund Wong

Posts: 154
Registered: 10/26/02
database update and charts
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 17, 2015 4:52 PM
Hi,

If I have a database on a server and I have an app that displays
charts in accordance to some criteria filter against this database.

Is it possible to have a chart update itself when new data is
inserted to the database (either from an external source or locally)?

Sorry if it is a stupid question. It's been a long time since
I've done any database apps.

Thanks

Edmund
Peter Below

Posts: 1,227
Registered: 12/16/99
Re: database update and charts
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 18, 2015 10:30 AM   in response to: Edmund Wong in response to: Edmund Wong
Edmund Wong wrote:

Hi,

If I have a database on a server and I have an app that displays
charts in accordance to some criteria filter against this database.

Is it possible to have a chart update itself when new data is
inserted to the database (either from an external source or locally)?

Sorry if it is a stupid question. It's been a long time since
I've done any database apps.

This completely depends on the database you use. Some have a mechanism
to send notifications to attached clients (Oracle, Interbase, Firebird
come to mind), others do not. In a database that supports this you
usually create a trigger on the database table you want to monitor (a
trigger for insert, update, delete usually) and the triggers sends the
notification. Clients need to explicitely subscribe and listen for the
notification, and that may need to be done in a secondary thread that
uses its own session.

--
Peter Below
TeamB
Francisco Alvar...

Posts: 83
Registered: 11/10/06
Re: database update and charts
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 18, 2015 10:54 AM   in response to: Edmund Wong in response to: Edmund Wong
Edmund Wong wrote:
Hi,

If I have a database on a server and I have an app that displays
charts in accordance to some criteria filter against this database.

Is it possible to have a chart update itself when new data is
inserted to the database (either from an external source or locally)?

Have you tried to use a timer to update the query or the graph?
Best Regards
Francisco Alvarado
Edmund Wong

Posts: 154
Registered: 10/26/02
Re: database update and charts
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 25, 2015 10:01 PM   in response to: Francisco Alvar... in response to: Francisco Alvar...
Francisco Alvarado wrote:
Edmund Wong wrote:
Hi,

If I have a database on a server and I have an app that displays
charts in accordance to some criteria filter against this database.

Is it possible to have a chart update itself when new data is
inserted to the database (either from an external source or locally)?

Have you tried to use a timer to update the query or the graph?
Best Regards
Francisco Alvarado
I think this is what I'll be doing. I'm still wrapping my head around
this though and maybe I'm complicating myself unnecessarily.

Thanks for the suggestion.

Edmund
Alan Jeffery

Posts: 56
Registered: 2/10/00
Re: database update and charts
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 6, 2015 12:30 AM   in response to: Edmund Wong in response to: Edmund Wong
Edmund Wong wrote:
Francisco Alvarado wrote:
Edmund Wong wrote:
Hi,

If I have a database on a server and I have an app that displays
charts in accordance to some criteria filter against this database.

Is it possible to have a chart update itself when new data is
inserted to the database (either from an external source or locally)?

Have you tried to use a timer to update the query or the graph?
Best Regards
Francisco Alvarado
I think this is what I'll be doing. I'm still wrapping my head around
this though and maybe I'm complicating myself unnecessarily.

Thanks for the suggestion.

Edmund

I suggest you use the timer to trigger an update query - as Francisco suggested. That does require that the form the graph(s) are on has to be running.

Alan
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02