REPLACE()

From Lianjapedia
Revision as of 09:22, 16 November 2011 by Lianjasupport (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to replace fields in the current record buffer without re-reading the current record

Syntax

REPLACE(<field>,<exp>)

See Also

REPLACE

Description

The REPLACE() function allows fields in the current record buffer to be modified without re-reading the record. The REPLACE function will update the <field> with the value stored in <exp>. The <exp> must be the same data type as the <field> being replaced. The REPLACE() function replaces data in the active record buffer, these changes are not written to disk until action is taken to commit the record. The REPLACE command is unlike the REPLACE() function, in that changes to the active record buffer are written to disk immediately.

Example

use accounts
replace(time, time())
replace(use, getenv("username"))
replace(date, date())