# isnomatch

### isNoMatch()

Return TRUE if the latest table operation did not have a match (normally means record just created).

## Arguments

Argument | Data Type | Description
None |  |

## Returns

TRUE if the latest table operation did not have a match (normally means record just created).

## 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 NO MATCH. This will normally happen, for example, if you are doing a 'Create Not Exist' operation and the row does not exist in the target table. That will normally mean that the row gets created.

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
isNoMatch() | dbexecsql("S", "update sourceTable set reason='No match' where rowid = '" & #rowid & "'") | Shows how to update a source record when there was no match in the target

## See Also

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