Re: ? Trapping 'RAISE EXEPTION' in Informix stored procedures & Delphi 3 C/S

I meet the same problem and solve it with checking count of values, returned from procedure. Also i keep all errors in procedure with ON EXCEPTION SET err_sql, err_isam, err_str INSERT INTO user_error VALUES (err_sql, err_isam, err_str); RAISE EXCEPTION err_sql, err_isam, err_str; END EXCEPTION; or ON EXCEPTION SET err_sql, err_isam, err_str CALL rollback_work_err(err_sql, err_isam, err_str); RAISE EXCEPTION err_sql, err_isam, err_str; END EXCEPTION; where procedure 'rollback_work_err' writes error into some (I use temporary) table. in program, after checking count of values returned i can call my error handling function... I also find some words about SQLCA structure in Delphi (for native driver - not ODBC), but i haven't time to check it. If You know somthing - write me please. Roman Soudakov (roma@tern.ru)