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)