RUNUPDATE

Updates the specified field with the value chosen.

RUNUPDATE(field// value // SQL // Server)

PARAMETERS

Field

The field to update

Value

The value to insert into the field

SQL

The SQL statement that will return the correct records to update.

Server

The server to execute this statement against (Note:  Use --- for local device)

To change change all phone numbers from 555-1313 to 555-1212:

RUNUPDATE("PhoneNumber"//"555-1212"//"SELECT * FROM CONTACTS WHERE PhoneNumber = '555-1313'"//"---")