Subject Is there a way to check if the table was modified?
Author un_spoken
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.

Thank in advance.

Regards.