Zeoslib Portal

Hey, how are we all this fine hour ?

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

Hi Nathan,

About the refresh problem without reconnect to the server, I don't know the solution by heart, but I'm pretty sure that information is somewhere available in the forum. It's quite FB specific, I believe.

Concerning the updating of other clients : See the recent posts about the TZIBEventAlerter. Using triggers on the database you can post 'event messages' to all database clients who are listening for that Event.

Mark

Hey,

Thanks for your reply, however I've searched the forum and Google extensively but I couldn't find any results which help my problem.

The Event Alerter you mentioned is good, and will be needed as a part of the solution for the problem, but the problem is still not completely solved.

Perhaps I am not using a proper search string, who knows. : )

Thanks for your time,

Hare Krishna !

~ Nathan

Try this one http://zeos.firmos.at/viewtopic.php?t=1017 ...

Ahh, that seems to be exactly what I'm after. Luckily this thing is due tomorrow, just have to test it out now. ;o

Sorry for the ignorance, but I guess other people who are after the same thing will see this too. Maybe I should get creative with my search strings in the future.

Thanks for your time, god bless, etc

~ Nathan

haha you are awesome Mark,

All glories to you !