Test.sql cannot find my test

[reykentj]

Env: SQL2005 Sp2 Visual Studio 2005 Could not find stored procedure 'sbSetupDeptProfitnLoss'. Test.sql has statement exec sbSetupDeptProfitnLoss 1, 10,'6/1/2006' A vb module in this project has Partial Public Class StoredProcedures Public Shared Sub sbSetupDeptProfitnLoss(ByVal BranchCode As Long, _ ByVal DepartmentCode As Long, _ ByVal RequestDate As Date) Dim DepartmentName As String Dim result As Object Dim stDocName As String Dim StartofMonth As Date Dim EndOfMonth As Date Dim StrStartofMonth As String Dim fnBuildBudgetQuery On Error GoTo Err_sbSetupDeptProfitnLoss sbGetDepartmentName(DepartmentCode, DepartmentName) StrStartofMonth = DatePart("m", RequestDate) & "/" & "01/" & DatePart("yyyy", RequestDate) StartofMonth = StrStartofMonth EndOfMonth = EOMonth(StartofMonth, 1) sbBuild_L1QueryDeptSalesDetail(BranchCode, DepartmentCode, StartofMonth, EndOfMonth) sbBuild_L1QueryDeptCostOfGoodsDetail(BranchCode, DepartmentCode, StartofMonth, EndOfMonth) sbBuild_L1QueryDeptExpensesDetail(BranchCode, DepartmentCode, StartofMonth, EndOfMonth) sbBuildDeptSummaryProfitnLossTable(DepartmentCode, RequestDate) stDocName = "rptDeptProfitnLoss" 'DoCmd.OpenReport(stDocName, acPreview) Exit_sbSetupDeptProfitnLoss: Exit Sub Err_sbSetupDeptProfitnLoss: fnHandleError("sbSetupDeptProfitnLoss") Resume Exit_sbSetupDeptProfitnLoss Resume End Sub End Class rkj

[Dave Kreskowiak]

Did you attribute this class and the sub appropriatly for use as a stored procedure? It doesn't look like it. Documentation on SqlProcedure attribute[^]

Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[reykentj]

Thank You Very Much. That Solved the problem:) rkj