Check if DB table has changed

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I'm writting a q&a chat application and hae a small refeshing IFRAME to
check if there has been a new or modified chat item written, if so the main
chat window refreshes and the datagrid gets refreshed with the new data.
My problem is the "check if there has been a change in the Database"

does any one know of a way that i could use to check if the data in the
table has changed.

Thanks all in advance
 
You could add a "LastModified" field to the DB.
Whenever you update a record, be sure to update that field.
Then you can just check that field to see if anything has changed since you
last checked.
 
Thanks for the reply but it's not a field i want to keep an eye on its the
whole table.
any ideas?

thanks anyway
 
Back
Top