You could include a date/time field somewhere in the database that is queried on a regular basis by your display function. Depending on the update rate, you could poll every second, every minute, or every hour. Any change of value would justify a full data retrieval and screen refresh.
The update process can lock the database using a transaction each time it performs an update, so the display program needs to be prepared for a denial of access for a few milliseconds. On Thu, 29 Jun 2006 19:50:09 +1000, Rob Menegon wrote: >Not sure whether I understand how this would occur. >The application is not doing or responsible for the updates to the database. >Its only function in life is to retrieve and display data. Updates, >modifications occur via another application, so I was incorrect in my >previous response to you - one user (app) doing updates and another >displaying data - independent processes. >-----Original Message----- >From: John Stanton [mailto:[EMAIL PROTECTED] >Sent: Thursday, 29 June 2006 2:51 PM >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] real time gui updates >In that case your application knows whenever the database is changed and can >call a refresh routine. >Rob Menegon wrote: >> No a single user/instance of the application reading from the database. >> >> >> >> -----Original Message----- >> From: John Stanton [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, 28 June 2006 10:45 PM >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] real time gui updates >> >> Rob Menegon wrote: >> >>>I have an application that displays data retrieved from various SQLite >>>tables. As the data within the tables changes I want these changes >>>reflected in the application real time. >>> >>>Can someone advise on the best way of doing this? >>> >>>Rob Menegon >>> >>> >> >> Do you have multiple independent users? >>
