Ingres 12.0 | Using Replace to Change a Database Row

Forms-Based Application Development Tools User Guide > Part 5: 4GL > J. Notes for Users of QUEL > QUEL Notes for the Writing 4GL Statements Chapter > Using Replace to Change a Database Row

Was this helpful?

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;

Last modified date: 08/28/2024