Note: This statement is named Set Recordset Row Value in the Add Statement dialog box.
Sets a field value in a recordset or data row.
This statement is also used by the CommitRecordsetRow statement.
Syntax
SetRowValue(Recordset/DataRow, "ColumnName", "Value")
Arguments
Argument | Description |
---|---|
Recordset/DataRow | Recordset or data row name. Must be opened with OpenRecordset or OpenRecordsetQuery. |
ColumnName | Column name to add the value to. |
Value | Value to set. |
Example
bugs = OpenRecordset("WysiCorp Bugs")
lastName = SetRowValue(bugs, "Last Name", "Jones")