CHANGE()

Class

Manual Locking

Purpose

Determine whether a record has been updated since it was last read

Syntax

CHANGE()

See Also

GATHER, READ, REPLACE , SET LOCKTYPE

Description

The CHANGE() function can be used in conjunction with SET LOCKTYPE TO OPTIMISTIC to determine whether a record has been updated since it was last read. If the records has been updated by another process since it was last read, the CHANGE() function will return .T. (TRUE), otherwise it will return .F. (FALSE).

Example

set locktype to optimistic
use customer
store automem
@1,1 get m.name
@2,1 get m.address
@3,1 get m.state
read
if not change()
    replace customer.name with m.name,;
      customer.address with m.address,;
      customer.state with m.state
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer