private void getProcedureInfoBtn_Click(object sender, EventArgs e)
{
CommandText =
"SELECT distinct p.proc_name, pc.id, pc.col, pc.proc_id, pc.datatype, pc.argtype, pc.width, pc.scale " + Environment.NewLine +
"FROM admin.sysproccolumns pc " + Environment.NewLine +
"LEFT JOIN admin.sysprocedures p " + Environment.NewLine +
"ON pc.proc_id = p.proc_id " + Environment.NewLine +
"LEFT JOIN admin.systabauth a" + Environment.NewLine +
"ON p.proc_name = a.tbl" + Environment.NewLine +
"WHERE (" + Environment.NewLine +
"(a.exe = 'y' AND grantee = (SELECT SUSER_NAME() FROM admin.syscalctable)) " + Environment.NewLine +
"OR (creator = (SELECT SUSER_NAME() FROM admin.syscalctable))" + Environment.NewLine +
")" + Environment.NewLine +
"AND p.proc_name LIKE ?" + Environment.NewLine +
"ORDER BY proc_name, argtype, id";
Helpers.ParamHelper ph = new Helpers.ParamHelper();
ph.Direction = ParameterDirection.Input;
ph.Name = "Procedure";
ph.Value = "%ProcNameHere%";
parameterBuilder1.SetParams(new Helpers.ParamHelper[] { ph });
}
private void getProcedureInfoBtn_Click(object sender, EventArgs e)
{
CommandText =
"SELECT distinct p.proc_name, pc.id, pc.col, pc.proc_id, pc.datatype, pc.argtype, pc.width, pc.scale " + Environment.NewLine +
"FROM admin.sysproccolumns pc " + Environment.NewLine +
"LEFT JOIN admin.sysprocedures p " + Environment.NewLine +
"ON pc.proc_id = p.proc_id " + Environment.NewLine +
"LEFT JOIN admin.systabauth a" + Environment.NewLine +
"ON p.proc_name = a.tbl" + Environment.NewLine +
"WHERE (" + Environment.NewLine +
"(a.exe = 'y' AND grantee = (SELECT SUSER_NAME() FROM admin.syscalctable)) " + Environment.NewLine +
"OR (creator = (SELECT SUSER_NAME() FROM admin.syscalctable))" + Environment.NewLine +
")" + Environment.NewLine +
"AND p.proc_name LIKE ?" + Environment.NewLine +
"ORDER BY proc_name, argtype, id";
Helpers.ParamHelper ph = new Helpers.ParamHelper();
ph.Direction = ParameterDirection.Input;
ph.Name = "Procedure";
ph.Value = "%ProcNameHere%";
parameterBuilder1.SetParams(new Helpers.ParamHelper[] { ph });
}
