Product Logo

CNS Query

Query your databases without relationships.

Script Steps

CNS Query Update Record By ID

NameCNS Query Update Record By ID

Updates a record in a table occurrence using its internal FileMaker record ID.

FormatCNS Query Update Record By ID ( File Name ; Table Name ; Field Values ; Record ID )
Required Parameters
Field Values

A return- or paragraph mark-separated list of “FieldName=FieldValue” pairs used to update the record. [Use “” to indicate returns in the field values.]

Record ID

The internal FileMaker record ID of the record to update.

Optional Parameters
File Name

The database file name.

Table Name

The name of the table occurrence that contains the record to update. [Specify “” to use the current layout Table Occurrence.]