_sql.au3 how to raise custom error in storage procedure

[begginner]

Hi I use _sql.au3 to connect to windows 2012. It works fine but I have problem using storage procedure.

If I use sp in Autoit script for example

$query1 = "exec PROCEDURE  '1paramiter','2paramiter ' ;"

if _SQL_Execute(-1,$query1)  = $SQL_ERROR   then Msgbox(0 + 16 +262144,"Error",_SQL_GetErrMsg())

Query using sp woks fine and return when is a error in query by   key violation or other native sql  errors. But if I want to raise my own custom error it’s not return by  _SQL_GetErrMsg() regardless of error number or severity. It seems to works fine in Management Studio  generate proper errors but no errors is return by $SQL_ERROR   or  _SQL_GetErrMsg()) in Autoit code.  I tried both THROW and RAISERROR.

Please tell me if is possibile to genarate custom errors

 

 

 

 

Sorry for my English

 

 

 

 

[Andreik]

You just need to add a COM Error handler and in your stored procedure be sure your error severity level is 16 or above.

PS: by the way, it's stored procedure not storage procedure

[mLipok]

Try to use my ADO.au3 UDF

[begginner]

Thanks Anderik for fast response . I still can't raise custom error thru stored procedure

Please check this example and tell me what am doing wrong

This is based on CrisL example script and create table with unique  computer name  key

create_table_small.au3

This is very simple stored procedure checking for duplicate computer entry and raising custom error

spTest.sql

Finally script  inserting duplicate key record directly and by using stored procedure

raiseerror.au3

Ps Hi mLipok I seen your ADO.au3 UDF  but I can't makes it work. There is  little examples of using it. I will try again in weekend when I will have more time

Sorry form my English