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);
}
/// <summary>
/// Removes lines.
/// </summary>
/// <param name="sprocSqlLines">The sproc SQL lines.</param>
/// <param name="wordThatLineStartContains">The word that line start contains.</param>
/// <param name="wordThatLineEndContains">The word that line end contains.</param>
/// <returns></returns>
public static string[] RemoveLines(string[] sprocSqlLines, string wordThatLineStartContains, string wordThatLineEndContains)
{
for (int i = 0; i < sprocSqlLines.Length; i++)
{
if (sprocSqlLines[i].ToUpper().Contains(wordThatLineStartContains))
{
while (!sprocSqlLines[i].Contains(wordThatLineEndContains))
{
sprocSqlLines[i] = string.Empty;
i++;
}
sprocSqlLines[i] = string.Empty;
break;
}
}
//Remove emplty lines
return(PervasiveToOracle.SplitMultiLines(string.Join(Environment.NewLine, sprocSqlLines)));
}
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();
}
private void btnGo_Click(object sender, EventArgs e)
{
txtOut.Text = PervasiveToOracle.ConvertPackageOfStoredProcs(txtIn.Text);
}