Deployment Error

[reykentj]

Error 1 Column, parameter, or variable #1: Cannot find data type GL_Record. Clrtest Microsoft.SqlServer.Server.SqlProcedure() Public Shared Sub sbSetupGLProbe(ByVal Selections As StoredProcedures.GL_Record) On Error GoTo Err_sbSetupGLProbe sbBuildGLQuery(Selections) Exit_sbSetupGLProbe: Exit Sub Err_sbSetupGLProbe: MsgBox(Err.Description) Resume Exit_sbSetupGLProbe End Sub This code will compile and deploy when the Sql Server attribute is omitted but then t_sql cannot see it. rkj

[Dave Kreskowiak]

It's saying that the type GLRecord doesn't exist, at least not in the StoredProcedures class or namespace. Why are you using "On Error Goto" when it's been deprecated by Try/Catch?

reykentj wrote:

This code will compile and deploy when the Sql Server attribute is omitted

What attribute? Let see the definition as it's supposed to be written.

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

[reykentj]

Error 1 Column, parameter, or variable #1: Cannot find data type GL_Record. Clrtest Public Class GL_Record Public AccountNo As String = "" Public AccountField As String = "" Public Year As Integer = 0 Public Month As Integer = 0 Public YTD As Decimal = 0 Public MTD As Decimal = 0 Public LastTransAmount As Decimal Public LastTransDate As Date = "01/01/01" Public LastTransBy As String = "" Public LastEffectiveDate As Date = "01/01/01" Public NumberOfTrans As Long = 0 End Class _ Public Shared Sub sbSetupGLProbe(ByVal Selections As GL_Record) Dim stDocName As String Dim result As Long = 0 On Error GoTo Err_sbSetupGLProbe sbBuildGLQuery(Selections) stDocName = "rptGL_Probe" 'DoCmd.OpenReport(stDocName, acPreview) Exit_sbSetupGLProbe: Exit Sub Err_sbSetupGLProbe: MsgBox(Err.Description) Resume Exit_sbSetupGLProbe End Sub On Error is being used because this is a conversion of small modules which may be later converted to try catch rkj

[Dave Kreskowiak]

Repost the code (Copy and Paste) and make sure you enable the "Ignore HTML tags in this message" checkbox before you hit "Post Message".

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

[reykentj]

Error 1 Column, parameter, or variable #1: Cannot find data type GL_Record. Public Class GL_Record Public AccountNo As String = "" Public AccountField As String = "" Public Year As Integer = 0 Public Month As Integer = 0 Public YTD As Decimal = 0 Public MTD As Decimal = 0 Public LastTransAmount As Decimal Public LastTransDate As Date = "01/01/01" Public LastTransBy As String = "" Public LastEffectiveDate As Date = "01/01/01" Public NumberOfTrans As Long = 0 End Class _ Public Shared Sub sbSetupGLProbe(ByVal Selections As StoredProcedures.GL_Record) Dim stDocName As String Dim result As Long = 0 On Error GoTo Err_sbSetupGLProbe sbBuildGLQuery(Selections) stDocName = "rptGL_Probe" 'DoCmd.OpenReport(stDocName, acPreview) Exit_sbSetupGLProbe: Exit Sub Err_sbSetupGLProbe: MsgBox(Err.Description) Resume Exit_sbSetupGLProbe End Sub Thank you for that suggestion. This code complies withou error but fails on deployment. rkj