Ingres 12.0 | putrow Statement--Use the Program to Update Table Field Data

Forms-Based Application Development Tools User Guide > Part 4: Embedded Forms Programming > Table Fields > Table Field Operations > putrow Statement--Use the Program to Update Table Field Data

Was this helpful?

putrow Statement--Use the Program to Update Table Field Data

The putrow statement enables your application program to update values in an existing row. The putrow statement has the following syntax:

putrow formname tablename [row]
(columnname = data {, columnname = data});

row

Specifies the number of the displayed row into which data is to be put. If row is omitted, the row on which the cursor currently sits is updated. If row is specified, it must identify a row currently displayed on the table field. You can use putrow inside an unloadtable loop. In that case, you must omit row because putrow updates the row currently being unloaded.

Only the columnnames specified receive new values; columns that are omitted are not changed. The value of data overwrites any value currently in the specified column.

Last modified date: 08/28/2024