Product Logo

CNS Query

Query your databases without relationships.

Script Steps

CNS Query Set Field Value By Find

NameCNS Query Set Field Value By Find

Sets the value of a single field using find criteria.

FormatCNS Query Set Field Value By Find ( File Name ; Table Name ; Field Name ; Field Value ; Find Criteria ; Case Sensitive )
Required Parameters
Field Name

The name of the field to set.

Field Value

The new value for the field.

Find Criteria

A return- or paragraph mark-separated list of “FieldName=FieldValue” pairs used to find the record to update. [Use “” to separate multiple values for a single field.]

Case Sensitive

If True, the plug-in will preserve the case in the find criteria. [Default is False.]

Optional Parameters
File Name

The database file name.

Table Name

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