> This might sound like a really idiotic newbie question, but I'm gonna
> ask anyway.
>
> Is there a way to find out if a row has been updated recently? Like a
> hidden time stamp somewhere?
>
> What I'm trying to do is do a select query on a table and display rows
> that have been changed or added in the last hour or so. Unfortunately I
> can't add another date/time field to the table because there's and
> existing application that's dependent on the structure so I can't change it.

Why? I think an additional column filled by a default value and/or
triggers shouldn't hurt existing applications. But right, these new
fields will be included in result sets if you are using SELECT * in the
application.

Another way is to go the "trigger-based log route", but IMHO for just
having when a last change was, this might be a bit too much. Although
there is tool support (IBLogManager) out there for a trigger-based log
route solution. ;-))


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!