Subject RE: [firebird-support] Is there a way to check if the table was modified?
Author Svein Erling Tysvær
>Hello.
>
>If I perform an update/ insert/ delete query on a given table does Firebird is storing somewhere the time of last change on this table?
>Or something like counter of changes? Can I pull this info out by writting a query?
>
>This would be very usefull for me because I need to pull out data from a table when it has been changed. Before pulling out the data I
>could check this marker and compare it with previous marker. If there was not any change I wouldn't have to pull out the data at all.
>
>I do not know if I make myself clear enough...:) If not please tell my, I will try to clarify.

Have you considered using events?

HTH,
Set