Programs / Predefined constants |
NOTFOUND is a predefined constant used to check if an SQL statement returns rows.
NOTFOUND
The NOTFOUND constant is used to test the execution status of an SQL statement returning a result, to check whether rows have been found.
The NOTFOUND constant is equal to 100.
You typically compare SQLCA.SQLCODE to NOTFOUND, after a SELECT statement execution.
MAIN DATABASE stores SELECT tabid FROM systables WHERE tabid = 1 IF SQLCA.SQLCODE = NOTFOUND THEN DISPLAY "No row was found" END IF END MAIN