SQL Anywhere database - ERROR MESSAGE

Author

ERROR MESSAGE

Luis Telles

2006-02-15, 1:23 pm

Hi, i am using ASA9.02 and i need to read the database error message, for
example:

execute @ret_status = usp_ACT_HOROM @a_fec_proceso,@a_co
d_obra,@a_login
if @ret_status <> 0
begin
select @errmsg='Error en usp_ACT_HOROM' + message database error...?
select @errnum=@ret_status
goto error
end

for example at PowerBuilder i use sqlca.sqlerrtex for read the message
error, what´s the same sqlca.sqerrtext at Transact....?

thanks

Luis Telles

Greg Fenton

2006-02-16, 3:23 am

Luis Telles wrote:
> select @errmsg='Error en usp_ACT_HOROM' + message database error...?

Have you looked at the ERRORMSG function?

In the SQLAnywhere 9.x online docs, see:
ASA SQL Reference
SQL Functions
Alphabetical list of functions
- ERRORMSG function [Miscellaneous]

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links