Using Replace to Change a Database Row
The QUEL replace statement is analogous to the SQL update statement. The following QUEL replace statement replaces any row in the Personnel table that has a value in the idnum column equal to the value in the idnum field on the current form.
replace personnel (salary = sal,
manager = manager)
where personnel.idnum = idnum;