Page 1 of 1

table update event

Posted: 24.12.2005, 22:50
by ~black.cat
People!
how to my application (delphi) get to know when table on server is changed?

now i check every minute for table change time (SHOW TABLE STATUS )
but its no good! (not quick updates on server)

Is there any event handler on zeos lib like
OnTableChanged

pleace help!
//sorry for my englisg, a`m russian spoken.
//do U understand my speach?
//Пацаны если вы меня поняли помогите плиз!

Posted: 25.12.2005, 00:03
by zippo
If you mean with the MySQL server, then the answer is simple: It can't. MySQL has no mechanism for data refreshing by the push method.

Sorry, don't understand Russian - how about Slovene (NOT slovakian)?
Če me razumeš, mi odgovori v našem jeziku. :):):)

Additional edit: I heard Firebird has such mechanism.

Posted: 25.12.2005, 00:15
by ~black.cat
oh my god...
I realy use mysqld and its too bad news!
rewriting some thousand strings for firebird not good idea.

i`m crying with crocodile tears (soviet union humor :)

But, Zippo, can you more type about this functionality
in firebird. May be some keyword for my google...
Thanks.

Posted: 25.12.2005, 11:43
by mdaems
Hi black cat,

I bet there's some more news about this functionality in the knowledgebase on this site.

Hapy Christmas and a Happy new year,
Mark