public string GetInsertStatement(object[] row)
{
StringBuilder a = new StringBuilder();
a.Append("INSERT INTO \"");
a.Append(Name);
a.Append("\" VALUES(");
for (int i = 0; i < iVisibleColumns; i++)
{
if (i > 0)
{
a.Append(',');
}
a.Append(Column.CreateString(row[i], GetColumn(i).ColumnType));
}
a.Append(')');
return(a.ToString());
}
private string GetDeleteStatement(object[] row)
{
StringBuilder a = new StringBuilder();
a.Append("DELETE FROM \"");
a.Append(sName);
a.Append("\" WHERE ");
if (iVisibleColumns < iColumnCount)
{
for (int i = 0; i < iVisibleColumns; i++)
{
a.Append('"');
a.Append(GetColumn(i).Name);
a.Append('"');
a.Append('=');
a.Append(Column.CreateString(row[i], GetColumn(i).ColumnType));
if (i < iVisibleColumns - 1)
{
a.Append(" AND ");
}
}
}
else
{
a.Append('"');
a.Append(GetColumn(iPrimaryKey).Name);
a.Append('"');
a.Append("=");
a.Append(Column.CreateString(row[iPrimaryKey],
GetColumn(iPrimaryKey).ColumnType));
}
return(a.ToString());
}
