# ismultiplematch

### isMultipleMatch()

Return TRUE if the latest table match operation matches more than one record. If the table operation is 'Create Not Exist', it will return TRUE if it matched any record.

## Arguments

Argument | Data Type | Description
None |  |

## Returns

TRUE if the latest table operation matched a more than one 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 matching more than one record. This will normally happen, for example, if you are doing a 'Update' operation and more than one row meeting the match criteria exist in the target table. That will normally mean that the rows do not get 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
isMultipleMatch() | dbexecsql("S", "update sourceTable set reason='Multiple match' where rowid = '" & #rowid & "'") | Shows how to update a source record when there were multiple matches in the target

## See Also

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