Exemplos de SqlDeveloperProject DatabaseHandler.AlterFunction em C# (CSharp)

Exemplo n.º 1

Arquivo: Procedures.cs Projeto: LuisDev99/NuoDB-With-CSharp-

        private void btnAlterProcedure_Click(object sender, EventArgs e)
        {
            string alterString = "ALTER PROCEDURE\"" + cmbSchemasDelete.SelectedItem.ToString() + "\".\"" + cmbDeleteProcedureName.SelectedItem.ToString() + "\"";

            alterString += txtAlterScript.Text;

            string status = dbHandler.AlterFunction(alterString);

            if (status == "Success")
            {
                MessageBox.Show("Procedure altered correctly");
                labelScript.Text         = alterString;
                txtAlterScript.Enabled   = btnDiscard.Enabled = btnAlterProcedure.Enabled = false;
                cmbSchemasDelete.Enabled = cmbDeleteProcedureName.Enabled = btnDeleteProcedure.Enabled = true;
            }
            else
            {
                MessageBox.Show("Something went wrong when altering procedure\nMessage: " + status);
            }
        }