By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,617 Members | 1,166 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,617 IT Pros & Developers. It's quick & easy.

Check if DB table has changed

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"mike" <sc******************@hotmail.com> wrote in message
news:qp****************@front-1.news.blueyonder.co.uk...
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

Nov 18 '05 #2

P: n/a
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

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:eh**************@tk2msftngp13.phx.gbl...
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"mike" <sc******************@hotmail.com> wrote in message
news:qp****************@front-1.news.blueyonder.co.uk...
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


Nov 18 '05 #3

P: n/a
Perhaps you missed my point. This field would keep track of if anything in
the whole table has changed.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"mike" <sc******************@hotmail.com> wrote in message
news:8I*****************@doctor.cableinet.net...
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

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:eh**************@tk2msftngp13.phx.gbl...
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"mike" <sc******************@hotmail.com> wrote in message
news:qp****************@front-1.news.blueyonder.co.uk...
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



Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.