Hi all,
i just discovered the ToTable() method on a view and its ability to
load only distinct values. nice!
....but i'm having issues with it returning duplicates. it seems to
work in some cases but not all. when i did a DISTINCT on the column
i'm trying to pull via SQL it only showed one entry (meaning there's
no a hidden space or something like that).
anyone seen such an issue?
//here i'm filtering my view
dvItemsInStock. RowFilter = "ProfArea=" + MyDB.GetSQLStri ng(sProfArea)
+ " AND Domain=" + MyDB.GetSQLStri ng(sDomain);
//attempting to create a table of DISTINCT Family, but it's returning
two rows with the same Family value for some reason...
DataTable dtFamilies = dvItemsInStock. ToTable(true, "Family");
i just discovered the ToTable() method on a view and its ability to
load only distinct values. nice!
....but i'm having issues with it returning duplicates. it seems to
work in some cases but not all. when i did a DISTINCT on the column
i'm trying to pull via SQL it only showed one entry (meaning there's
no a hidden space or something like that).
anyone seen such an issue?
//here i'm filtering my view
dvItemsInStock. RowFilter = "ProfArea=" + MyDB.GetSQLStri ng(sProfArea)
+ " AND Domain=" + MyDB.GetSQLStri ng(sDomain);
//attempting to create a table of DISTINCT Family, but it's returning
two rows with the same Family value for some reason...
DataTable dtFamilies = dvItemsInStock. ToTable(true, "Family");