Get notified on table-change.

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Get notified on table-change.

Post by GEswin » Mon 22 Nov 2004 15:19

Hi, I need in a certain case alert a user when a table got a new record. Is there any callback method or similar ? Right now I use a timer that does a recordcount of that table (select sum(*) from table). is there any better way to do this ? Or get some CRC of the table, or similar ?

thanks in advance,

J.Pieter Vos

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Get notified on table-change.

Post by Ikar » Mon 22 Nov 2004 16:22

MySQL server doesn't provide such functionality.
Probably, timestamp fields will more suit for your task.

Post Reply