Results 1 to 2 of 2

Thread: Networked Database

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Hamilton, New Zealand
    Posts
    137

    Post

    My application will have the same program running on several maybe 5 different computers across a network. This program will access a central database on a file server and will add records or delete and modify records.

    What I need is a way to detect if the recordset/database has been updated or something that will alert the program when it is update so that I can refresh my datagrids etc.

    I do not really want to put a button that the user has to click to refresh the display. Nor do I want the grid to update at regular intervals as that may not be needed and would only use up extra resources.

    Any help would be appreciated.

    Thanks

    Matt Brown

  2. #2
    Junior Member
    Join Date
    Nov 1999
    Location
    Forsyth, GA, USA
    Posts
    26

    Post

    You could maintain a field in some kind of "control" table in the database that could contain the date/time of the last database update. Querying this with a timer control on the workstation app would let you update automatically. Setting the date/time with each update would make it work.

    Also, look to the properties available to you with the data objects you are using. They may have a similar value you could query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width