table property

[Ruslan Zasukhin]

On 2/19/11 4:24 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George, 

> hello all,
> is it possible to get a 'timestamp' of when a table has been modified?

We do not have such feature in Valentina..

You know any db which have this?
So we can take a look ?

> modified could be anything...add/delete/update records, fields, links, indexes
> etc.

May be this can be done with help of triggers ...

And you can use exactly feature of Valentina
    PROPERTY OF TABLE   to store last timestamp ...

 
> i need to maintain some local copies of a remote db's tables.
> for a given table, i want to avoid refreshing the local copy if nothing has
> changed in the remote db throughout the day...hence the timestamp.
> 
> thanks,
> george parkinson

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]