private void btnGo_Click(object sender, EventArgs e)
        {
            String SQL       = txtIn.Text.ToUpper();
            string tableName = txtTableName.Text.ToUpper();

            //Check the user has entered the correct table name
            if (SQL.Contains(tableName) == false)
            {
                DialogResult dlgRes = MessageBox.Show("Did you enter the correct Table Name: " + txtTableName.Text + " ?" + Environment.NewLine + "It doesn't exist in the Tabnle Definition script you pasted in!", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
                //Exit if user needs to correct the table name
                if (dlgRes == DialogResult.No)
                {
                    return;
                }
            }

            //insert drop table
            SQL = PervasiveToOracle.DropObject(enums.ObjectType.table, tableName) + SQL;

            //convert datatypes
            SQL = PervasiveToOracle.ConvertDataTypes(SQL);

            //remove parameter quotes
            SQL = TableOps.RemoveQuotesAroundParameters(SQL);

            //Make a script to migrate the data in the table
            txtPopulateScript.Text = PervasiveToOracle.MigrateDataScript(SQL, tableName);
        }
Ejemplo n.º 2
0
        private void btnGo_Click(object sender, EventArgs e)
        {
            String SQL       = txtIn.Text.ToUpper();
            string tableName = txtTableName.Text.ToUpper();

            //Check the user has entered the correct table name
            if (SQL.Contains(tableName) == false)
            {
                DialogResult dlgRes = MessageBox.Show("Did you enter the correct Table Name: " + txtTableName.Text + " ?" + Environment.NewLine + "It doesn't exist in the Tabnle Definition script you pasted in!", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
                //Exit if user needs to correct the table name
                if (dlgRes == DialogResult.No)
                {
                    return;
                }
            }


            //insert drop table
            SQL = PervasiveToOracle.DropObject(enums.ObjectType.table, tableName) + SQL;

            //convert datatypes
            SQL = PervasiveToOracle.ConvertDataTypes(SQL);

            //remove parameter quotes
            SQL = TableOps.RemoveQuotesAroundParameters(SQL);

            SQL = SQL + TableOps.GetTableSpaceDefinition();

            //remove primary keys
            SQL = TableOps.RemovePrimaryKeys(SQL, tableName);

            //Grant CRUD Access
            if (chkGrantAccess.Checked)
            {
                SQL = PervasiveToOracle.GrantCRUDAccess(SQL, tableName);
            }

            txtOut.Text = SQL;

            txtOut.SelectAll();
        }