/// <summary>
/// Check If Procedure Exists
/// </summary>
public static bool ProcedureExists(string procedureName)
{
var databaseName = SboApp.Application.Company.DatabaseName;
var count = SboRecordset.NonQuery(FrameworkQueries.Instance.ProcedureExistsQuery(databaseName, procedureName));
return(count > 0);
}
/// <summary>
/// Drops Procedure If It Exists
/// </summary>
public static void DropProcedureIfExists(string procedureName)
{
var databaseName = SboApp.Application.Company.DatabaseName;
if (ProcedureExists(procedureName))
{
SboRecordset.NonQuery(FrameworkQueries.Instance.DropProcedureIfExistsQuery(databaseName, procedureName));
}
}
