Problem with execution
From: Johny (goky2002_at_beograd.com)
Date: 10/22/04
- Next message: Bob Dalton: "Re: Microsoft Access and the Jet Engine"
- Previous message: Michal R: "ADO - permanent memory leak?!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 22 Oct 2004 16:11:24 +0200
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
- Next message: Bob Dalton: "Re: Microsoft Access and the Jet Engine"
- Previous message: Michal R: "ADO - permanent memory leak?!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
