// 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); }