Subject | Is there a way to check if the table was modified? |
---|---|
Author | un_spoken |
Post date | 2013-05-24T13:20:47Z |
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.
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.