Search the Community
Showing results for tags '_sql.au3'.
Found 1 result
-
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