🚀 go-pugleaf

Hello,

I use a stored procedure on SQL Server like that :

---------------------------------
CREATE PROCEDURE Test @v_Id1 int, @v_Libelle1 varchar(20), @v_Id2 int,
@v_Libelle2 varchar(20)
AS

declare @v_res = 0

INSERT INTO TABLE1 (TAB_ID; TAB_LIBELLE) VALUES (@v_Id1, @v_Libelle1)

if @@ERROR <> 0
  @v_res = 1

if @v_res=0
begin
  INSERT INTO TABLE2 (TAC_ID; TAC_LIBELLE) VALUES (@v_Id2, @v_Libelle2)
  if @@ERROR <> 0
  @v_res = 2
end
if (res = 0)
begin
/*
   ...
*/
end

return (@v_res)
---------------------------------

Sometimes, this procedure raises an error on one of the insert call. I would
like to read the @v_res value in my C++ Builder program.

I try the following code but it doesn't work. If the execProc fails, the
value is always 0.

try
{
   maprocStock->ExecProc();
    res =(int)maprocStock->Parameters-> ParamValues["@v_codeRetour"];
}
catch(Exception &newDBException)
{
     // @v_codeRetour is a 'pdReturnValue' parameter pdReturnValue
     res =(int)maprocStock->Parameters-> ParamValues["@v_codeRetour"];
 }

First question : How can I read the good value ?
Second question : How can I read the exception code ? I only get the
message.

Thanks a lot


Bruno