dml

Control the behaviour of Interchange inserts and updates triggered by calls to the [update data] tag.

Valid values

Valid values are "preserve", "strict" or no value at all.

The default is no value at all.

Description

This pragma controls the mechanism used by Interchange when inserting or updating data in a table using [update data]

If no value is set then Interchange will check whether a row exists before attempting to insert a new row.  If a row with the specified primary key exists then an UPDATE will be performed instead of an INSERT.

If this pragma is set to "preserve" then Interchange will only attempt to INSERT rows.  If the specified primary key already exists then the INSERT will fail and no attempt to fall back to a SQL UPDATE will be made.

If this pragma is set to "strict then the selected INSERT or UPDATE mode will be strictly enforced.

Availability This pragma was introduced in version 5.5.2, and is therefore not available for use with any earlier Interchange version.