// Sql to delete multiple rows of data from named table
void DeleteValuesQuery(DataTableSql other)
{
_database.OpenStatement();
// SQL does positional matching, so column order must come from other
var sql = _gen.DeleteNamed(TableName, other.Heading, other.GetQuery()); //WRONG?
_database.ExecuteCommand(sql);
_database.CloseStatement();
}
// Compare tables: joinop is INTERSECT, MINUS or NUL (for equals)
bool SetCompare(DataTableSql other, JoinOps joinop, bool both)
{
Logger.Assert(Heading.Equals(other.Heading));
var sql = _gen.SelectOneWhere(GetQuery(), other.GetQuery(), joinop, both);
var ret = GetBoolValue(sql);
Release();
other.Release();
return(ret);
}