Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Table Modification Stamp???

Table Modification Stamp???

From: <tim.mcconechy_at_runtime.dk>
Date: Wed, 17 Feb 1999 09:32:45 GMT
Message-ID: <7ae2bt$its$1@nnrp1.dejanews.com>


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 - 03:32:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US