Hello,
We're seeing a strange situation with our Section Access that we've never seen before.
We have a Subjects table in our database with a field (SubjID) who's data type is (PK, int, not null). The values are straight forward. For example:
| SubjID |
Name |
| 1 |
Bob Smith |
| 2 |
Jim Longley |
| 3 |
Sarah Whitely |
Our section access query is:
SQL select 'USER' as "ACCESS", upper('MYDOMAIN\MYUSERID') as "USERID", '*' as "GROUP", null as "OMIT", SubjID as "Subject" from Subjects;
Our application body has the following query:
[Subjects]:
SQL select SubjID as Subject, Name from Subjects;
The above does not work; the table is read but I get no access to the data. However, if I change the above query to the following:
[Subjects]:
Load *, num(SubjID,'0') as Subject;
SQL select SubjID, Name from Subjects;
The above does work. Any idea why the internal representation of the Subject field in the Section Access query would differ from the representation of the same field in the [Subjects] table, such that section access works in one case but not the other?
Thanks,
Steven
