SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:58 AM
| ||||
| ||||
 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.      |
|
04-20-2008, 11:59 AM
| |||
| |||
| Re: Error trapping Guido Jimenez M. wrote: > 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. Does 'stty -a' show the the 'intr' key is DEL or is that the 'quit' key? Check your users' key mappings! Art S. Kagel <SNIP> |
|
04-20-2008, 11:59 AM
| ||||
| ||||
| Re: Error trapping Guido Jimenez M. wrote: > 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. Does 'stty -a' show the the 'intr' key is DEL or is that the 'quit' key? Check your users' key mappings! Art S. Kagel <SNIP> |
Linear Mode
