/// <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)); } }