LUPDATE( ) Function

  • Article

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

See Also

DIR | FDATE( ) | FTIME( )