REPLACE AUTOMEM

Purpose

Update fields with values stored in correspondingly named memory variables

Syntax

REPLACE AUTOMEM

See Also

CLEAR AUTOMEM, GATHER, READ, SCATTER, STORE AUTOMEM, USE

Description

The REPLACE AUTOMEM command updates fields in the current record of the active table. It assumes the existence of memory variables that match the fields in terms of name, data type and size. Such memory variables can be generated automatically using the STORE AUTOMEM or USE…AUTOMEM commands.

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 automem
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer