Access control rule sql parameter incorrect with data access objects SelectSingle().

I have a problem where the sql statement parameters are generated incorrectly when I combine access control rules with data access objects selectsingle method. Specifically, the access control rule parameter is incorrect. (I'm using 8.7.6 asp.net c#)

When I call SelectSingle(record_id), the filter for the record_id is generated correctly with parameter =@p0. I also have registered an access control rule to filter all records using another_id, but the parameter generated is also =@p0 instead of =@p1. Because the parameter is wrong, the correct record is never returned.

I understand why the call to data access objects would process the rules, but it needs to generate the parameters correctly for it to work.
1 person has
this question
+1
Reply