Equinox Online Help - Language Reference - A to Z
LookupWrite |
|
---|---|
Applies to | |
Syntax | LookupWrite ValueExpression, FieldName [, SearchExpression, IndexName] [, operator, LimitfieldName] |
Action | [Statement] Writes a field value to a record in an unrelated table. |
Scope | Usable anywhere. |
Notes | This statement is similar to the Lookup function in that it uses SearchExpression, IndexName, operator and LimitfieldName to locate a record in a remote table. Rather than reading the value from the remote record, this statement writes a new value into the specified field (FieldName). ValueExpression supplies the new field value. Note that you cannot use this statement to write a picture field value. After the statement is executed, the SysError system workarea may take one of the following values:
|
Category | Record location |
See Also | CountRecords, CurrentTableName, FindRecord, FindRecordLock, GroupFindRecord, IsLookup, IsRecord, IsSameRecord, Lookup, SameRecord |
Example | This example uses the Lookup and LookupWrite statements to update a stock field in another table. number qty |