Check Store Procedure Name Exists or Not
Hi All
Please kindly check this code for Store Procedure Exists or not .
''' <summary>
''' To Check Store Procedure Exists or Not
''' </summary>
''' <param name="SPName">Pass Store Procedure Name</param>
''' <returns>return TRUE or FALSE</returns>
''' <remarks>To Check Whether Store Procedure Exists or Not</remarks>
Public Function CheckSPExists(ByVal SPName As String) As Boolean
otempRecset = oApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
otempRecset.DoQuery("SELECT CASE COUNT('A') WHEN 1 THEN 'EXISTS' ELSE 'NOT EXISTS' END FROM Sys.objects WHERE Name =" & SPName & "AND Type = 'P'")
If otempRecset.RecordCount > 0 Then
Return True
Else
Return False
End If
End Function