Click or drag to resize

LUpdate Function (Usual)

X#
Return the date a database file was last modified and closed.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.19
Syntax
Copy
 FUNCTION LUpdate(
	uArea AS USUAL
) AS DATE
Request Example View Source

Parameters

uArea
Type: Usual
Specifies the work area name or number for a table from which the value must be retrieved.

Return Value

Type: Date
The date of last change.
If there is no database file in use, LUpdate() returns a NULL_DATE.
Remarks

By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
Examples
This example demonstrates that the modification date of a database file is not changed until the database file is closed:
X#
Copy
1QOut(TODAY())                // Result: 09/01/90
2USE sales NEW
3QOut(LUpdate())            // Result: 08/31/90
4APPEND BLANK
5QOut(LUpdate())            // Result: 08/31/90
6DBCloseAll()
7USE sales NEW
8QOut(LUpdate())            // Result: 09/01/90
This example uses an aliased expression to return the last modification date of a database file in an unselected work area:
X#
Copy
1USE sales NEW
2USE customer NEW
3QOut(LUpdate(), Sales->LUpdate())
See Also