The rowId argument specifies the automatically generated row identifier field of the record that will be affected by the specified operation. By default, this field is named "RowId" and is the <primary key> of a table. The name of this field can be changed, however, and/or the <primary key> can be set to a different field. Even if the name of the "RowId" field is changed, or if some other field is designated as the <primary key>, the rowId argument always applies to the first field listed under the 'Your Fields' section of the Design View tab. This "RowId" field automatically generates new incremental integer values on insert. This field cannot be deleted from a table. An exception is thrown in the case that there is no record with a RowId matching the specified rowId argument value.
|