>I need to write code that checks if records with specific data exist in a table .
Look at the SQL-Select command:
select * ;
from TheTable ;
into cusor TheFoundData ;
where SomeField = 2if ( _tally > 0 )
* matching data is in thereelse * no matching data is in thereendif