If-Then-Else Example

If-Then-Else Example¶

The following IF statement performs a delete or an insert and checks to make sure the statement succeeded:

IF (id > 0) AND (id <= maxid) THEN       DELETE FROM emp WHERE id = :id;       IF iierrornumber > 0 THEN              message 'Error deleting specified row';              return 1;       ELSEIF iirowcount = 0 THEN              message 'Specified row does not exist';              return 2;       ENDIF;ELSEIF (id < maxid) THEN       INSERT INTO emp VALUES (:name, :id, :status);       IF iierrornumber > 0 THEN              message 'Error inserting specified row';              return 3;       ENDIF;ELSE    message 'Invalid row specification';    return 4;ENDIF;