# issinglematch

### isSingleMatch()

Return TRUE if the latest table match matches a single record. This normally means a record will be updated.

## Arguments

Argument | Data Type | Description
None |  |

## Returns

TRUE if the latest table operation matched a single record in the target.

## Description

This function is normally used as a test expression in the Table Pre and Post Operation expression tab. It is used to check if the table match just completed resulted in a SINGLE or UNIQUE MATCH. This will normally happen, for example, if you are doing a 'Update' operation and the row does exist in the target table. That will normally mean that the row gets updated.

You should not use it in the 'Add Fields' or 'Change Data' tabs, because at this point Inaport has not touched records.

## Examples

Test Expression | Evaluation Expression | Description
isSingleMatch() | dbexecsql("S", "update sourceTable set reason='Single match' where rowid = '" & #rowid & "'") | Shows how to update a source record when there was a single match in the target

## See Also

Pre and Post Expressions, pk() and parentpk(), isnomatch(), ismultiplematch(), matchresult()