====== RowExists function ====== ==== Description ==== Determines whether all rows specified in //rowlist// are in the specified native table. ==== Syntax ==== //truefalse// = **RowExists**(T//ableName//, R//owList, 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 ==== [[tableexists|TableExists()]] ==== 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)