rsMergeDelete

Analogous to rsMergeReplaceOnly, except matching rows in the ResultSet rsNameTarget are removed instead of replaced. It is useful for removing rows from one ResultSet that already occur in another.

Type and Usage

Parameters

Takes three parameters:

  • The first parameter (rsNameTarget) is the ResultSet that will be modified by the merge.

  • The second parameter (rsNameSource) is the ResultSet containing the rows that will be merged into the target.

  • The third parameter (rsCommonField) is the field that occurs in both results sets that will be used as the test for which rows to remove from rsNameTarget.

Output

  • Returns TRUE if the function is successful.

  • Returns FALSE if the function fails.

Example

<$rsMergeDelete(rsNameTarget, rsNameSource, rsCommonField)$>