At the moment, I have found ZeOS and Firebird as a great combination for an University assessment item, however I am faced with one problem !!!
When two instances of the program are running on separate computers, and one user adds information to a table, is there any easy way to update this table as soon as the information is added, for all other users connected to the database ?
The application is a simple staff/client management system. I was thinking of making a separate server application and once someone updates a table, it will let all the other people connected know, and then execute a command to update the tables.
So far though, the only way I am able to update the tables is by disconnecting and reconnecting to the server. This is easy, but also not very friendly, and would put some strain on the server (not that a few people would effect it, but efficiency would be a nice thing to have.)
I was thinking, the server will have to let the other users connected know anyway, so perhaps there is some ability with the Firebird server to do this.
Either way, I'm sure you understand my problem. I've only being using Firebird and ZeOS for about a month so far, so I'm not too expert, but know enough to get by. ;o
Any help would be greatly appreciated
Thankyou for your time. All glories to you!
~ Nathan
