🚀 go-pugleaf

I have Stored procedure spAdmin_Do And I try to execute it with

adospDo->Close();
            adospDo->ProcedureName = "spAdmin_Do";
            adospDo->Parameters->Clear();
            spparamFilterRequest = adospDo->Parameters->AddParameter();
            spparamFilterRequest->DataType = ftString;
            spparamFilterRequest->Size = 10;
            spparamFilterRequest->Value = asYear;
            adospDo->ExecProc();

 The procedure simply stop at the first EXEC 'delete Do.dbo.Admin_Do' and
don't continue.
 If I delete that line procedure again stop at the first EXEC.

 Is it problem if I have more EXEC in procedure or How can I solve this on
some different way?

The procedure spAdmin_Do:


CREATE PROCEDURE spAdmin_Do
(
 @sFiscalYear  varchar(10)
)
AS
   @sQueryPart1  varchar(1000),
   @sQueryPart2  varchar(1000),
   @sQueryPart3  varchar(1000)

SET @sQueryPart1 = " Some query "
SET @sQueryPart2 = " Some query "
SET @sQueryPart3 = " Some query "

SET DATEFORMAT dmy
Exec ('delete Do.dbo.Admin_Do')
EXEC(@sQueryPart1)

EXEC(@sQueryPart2)
EXEC(@sQueryPart3)
GO