Error trapping
Fellows,
I am trying to trap SQL error using the SQL INTERRUPT ON statement, but the program still abort when the user press the DEL key.
Some of the program ....
WHENEVER ERROR CONTINUE
OPTIONS ....
SQL INTERRUPT ON
DECLARE q_xxx CURSOR FOR
SELECT some_fields
FROM some_table
WHERE some_condition
FOREACH q_xxx INTO some_var
IF int_flag THEN
IF sqlca.sqlcode = -213 THEN
ERROR "Interrupt by user"
SLEEP 2
RETURN
END IF
END IF
END FOREACH
......
Some help will be appreciate .!
Thank you in advance .!!!
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1'/min.