table property

[George Parkinson]

hi ruslan,
i can't think of one that has such a feature.
the db that i'm migrating from is codebase (client/server using foxpro dbfs) 
claims to have such a feature but i've never seen it work.

triggers - yes - that should do nicely!
(i'm still very new to the sql stuff)

thanks for help,
george




----- Original Message ----
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Sent: Sat, February 19, 2011 3:06:52 PM
Subject: Re: table property

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina