Re: Table Modification Stamp???

OOPS ! must get those reading glasses

Alex

Mike Burden wrote:

> I presume you mean the data not the table structure.
>
> How about adding a trigger that updates a single row/column table with a
> timestamp or sequence number. You can then test whether this value has changed.
> Or have a dummy row on the table that is updated each time a change is made,
> again via a trigger.
>
> tim.mcconechy_at_runtime.dk wrote:
>
> > Is there any way to see if a table has been modified.
> > Via a certain date or stamp or something.
> >
> > All I want is to see if a table has changed at some
> > point since a specific date.
> >
> > For example:
> > I have a largish table 2000 records that is slow to open.
> > I need the whole table in my app.
> > I can make the table locally in a Foxpro table
> > and only update it when the server table has changed which is not that often.
> >
> > SO it could check for example a modification date and
> > If it has changed since the last check begin to update the local table.
> > Otherwise use the local copy.
> >
> > Any other ideas...
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 17 1999 - 04:23:16 CST