Frozen TimeStamps

[Greg Rodgers]

Hello,

I have a database in which users update information and
the info is timestamped.

When I query this data, I use a select query to pull the
last update (Timestamp) only. This seems to work, but
every now and then its seems that the query gets stuck on
the third to last timestamp and will not pull the last
update.

Does anyone have any Ideas as to why this may happen?

Greg Rodgers

 

[John Vinson]

When I query this data, I use a select query to pull the
last update (Timestamp) only. This seems to work, but
every now and then its seems that the query gets stuck on
the third to last timestamp and will not pull the last
update.

Does anyone have any Ideas as to why this may happen?

No clue. Care to post the SQL view of the query, and the circumstances
under which incorrect data is pulled?