Function.ODBC.ConnectionName!RecordsetName.Set

Set is used with the Update functionality to change the database information either by updating an existing row or adding a new row with the AddNew function. The alternate syntax sets the specified recordset field to the truncated passed value. You may have unpredictable results when using this with non-text fields.

Syntax

Function.ODBC.ConnectionName!RecordsetName.Set!FieldName(“Value to set”) or

Function.ODBC.ConnectionName!RecordsetName.Set!FieldName(value, truncate length)

Arguments

Value to set

This is a value you want the specified field to be

Example

Function.ODBC.testCon!testrst.Set!FirstName(“George”)