Description
Determines whether all rows specified in rowlist are in the specified native table.
Syntax
truefalse = RowExists (TableName, RowList, KeepCaseFlag)
Parameters
The RowExists SSP function has the following parameters.
| Parameter | Description |
|---|---|
| Tablename | An attached table. |
| Rowlist | One or more keys, @FM-delimited. |
| KeepCaseFlag | A boolean field. Defaults to 0. By default the function will convert all values to uppercase. By setting the KeepCaseFlag to 1, the function will look for an exact match. |
Note: If even one specified row does not exist in tablename, then RowExists returns false.
Returns
1 (True) if all the rows exist, or 0 (False) if any of the rows do not exist.
See also
Example
* Check to see if 'nj' is a record in the STATE table. The first call will return True,
* the second call will return False.
Declare Function RowExists
a = RowExists('STATE', 'nj')
KeepCaseFlag = 1
b = RowExists('STATE', 'nj', KeepCaseFlag)
