public void RefreshIndices()
{
string cmd_index = IndexSQLStatementsClass.Instance().GetIndiciesByName(_dbReg.Version, IndexName.Trim());
DataFilled = false;
txtConstraintName.Text = IndexName.Trim();
try
{
var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg));
con.Open();
string PkColumn = string.Empty;
string IndexName = string.Empty;
string IndexColumnName = string.Empty;
int Unique = 0;
FbCommand fcmd = new FbCommand(cmd_index, con);
var dread = fcmd.ExecuteReader();
if (dread.HasRows)
{
while (dread.Read())
{
TableName = dread.GetValue(0).ToString().Trim();
IndexColumnName = dread.GetValue(2).ToString().Trim();
Unique = StaticFunctionsClass.ToIntDef(dread.GetValue(3).ToString().Trim(), 0);
string[] lv = new string[1];
lv[0] = IndexColumnName;
}
DataFilled = true;
}
con.Close();
}
catch (Exception ex)
{
_localNotify?.AddToERROR(StaticFunctionsClass.DateTimeNowStr() + "->NotNullForm->RefreshIndices()->" + ex.Message);
}
}
public string RefreshIndicesAndGetTablename()
{
string cmd_index = IndexSQLStatementsClass.Instance().GetIndiciesByName(_dbReg.Version, IndexName.Trim());
DataFilled = false;
txtIndexName.Text = IndexName.Trim();
string TableName = string.Empty;
try
{
lvFields.Items.Clear();
var con = new FbConnection(ConnectionStrings.Instance().MakeConnectionString(_dbReg));
con.Open();
string pkColumn = string.Empty;
string indexName = string.Empty;
string indexColumnName = string.Empty;
string oldIndexColumnName = string.Empty;
int Unique = 0;
int IndexType = -1;
bool Active = false;
FbCommand fcmd = new FbCommand(cmd_index, con);
var dread = fcmd.ExecuteReader();
lvFields.Items.Clear();
if (dread.HasRows)
{
while (dread.Read())
{
TableName = dread.GetValue(0).ToString().Trim();
indexColumnName = dread.GetValue(2).ToString().Trim();
Unique = StaticFunctionsClass.ToIntDef(dread.GetValue(3).ToString().Trim(), 0);
Active = StaticFunctionsClass.ToIntDef(dread.GetValue(4).ToString().Trim(), 0) != 1;
IndexType = StaticFunctionsClass.ToIntDef(dread.GetValue(5).ToString().Trim(), 0);
cbUnique.Checked = Unique > 0;
ckActive.Checked = Active;
if (IndexType < 0)
{
rbSortNothing.Checked = true;
}
else if (IndexType == 0)
{
rbSortAscending.Checked = true;
}
else if (IndexType == 1)
{
rbSortDescending.Checked = true;
}
string[] lv = new string[1];
lv[0] = indexColumnName;
if (this.oldIndexColumnName != indexColumnName)
{
ListViewItem lvi = new ListViewItem(lv);
lvFields.Items.Add(lvi);
this.oldIndexColumnName = indexColumnName;
}
}
DataFilled = true;
}
con.Close();
}
catch (Exception ex)
{
_localNotify?.AddToERROR($@"{StaticFunctionsClass.DateTimeNowStr()}->IndexForm->RefreshIndicesAndGetTablename()->{ex.Message}");
}
return(TableName);
}
