Hi, I just recently came across the following error "These columns don't currently have unique values"
After troubleshooting I came across the problem but I still do not know of a solution. I will describe the problem
in further detailing including my troubleshooting steps.
The problem with the above error seems to be related to multiple child items which each belongs to
different parent nodes.
After going through testing the store procedure and rerunning the application, I modified the stored procedure and discovered that if I returned several child items with the same id regardless if it belongs to a separate parent then the above error will occur.
For example:
ParentID ID Name
null 1 "John"
null 2 "Ben"
1 9 "apples"
1 10 "pears"
2 9 "pears"
2 11 "bananas"
but if I removed the column 2, 9, "pears" then it will work such as
ParentID ID Name
null 1 "John"
null 2 "Ben"
1 9 "apples"
1 10 "pears"
2 11 "bananas"
Please help because I am stumped on this functionality and would like it working soon as it is the final piece of code to get the entire feature functioning correctly.
Regards
After troubleshooting I came across the problem but I still do not know of a solution. I will describe the problem
in further detailing including my troubleshooting steps.
The problem with the above error seems to be related to multiple child items which each belongs to
different parent nodes.
After going through testing the store procedure and rerunning the application, I modified the stored procedure and discovered that if I returned several child items with the same id regardless if it belongs to a separate parent then the above error will occur.
For example:
ParentID ID Name
null 1 "John"
null 2 "Ben"
1 9 "apples"
1 10 "pears"
2 9 "pears"
2 11 "bananas"
but if I removed the column 2, 9, "pears" then it will work such as
ParentID ID Name
null 1 "John"
null 2 "Ben"
1 9 "apples"
1 10 "pears"
2 11 "bananas"
Please help because I am stumped on this functionality and would like it working soon as it is the final piece of code to get the entire feature functioning correctly.
Regards