LUPDATE( ) Function
Visual Studio .NET 2003
Returns the date on which a table was last updated.
LUPDATE([nWorkArea | cTableAlias])
Return Values
Date
Parameters
- nWorkArea | cTableAlias
- Returns the last update to a table open in another work area. nWorkArea specifies the work area number and cTableAlias specifies the table alias. LUPDATE( ) returns the date of the last update to the table in the currently selected work area if you omit nWorkArea and cTableAlias.
If no table is open in the work area you specify, LUPDATE( ) returns a blank date. If no table has the alias you specify, Visual FoxPro generates an error message.
Remarks
This function is useful in update procedures.
LUPDATE( ) queries Windows to determine the date a table was last updated. However, the last two digits of the year the table was last updated are stored the table header.
Example
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'data\testdata') USE customer && Open Customer table CLEAR ? LUPDATE( ) && Displays date of last update
