Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i need to limit records according to users,
i add this code to my load script:
Star is *;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, CARDCODE
ADMIN, ADMIN, P, *
USER, DEMO1, P, XXXXX
];
Section Application;
i have a CARDCODE column in one of my tables.
i also checked the "intial data reduction based on section access" on the "document properties" page.
when opening the qv file it doesnt asc for any user/password and all data are displayed.
thanks
shlomo
Hi,
Can you make Upper(CARDCODE) in the script and then try the same.
Regards,
Ravi
Hello Shlomo
Are you sure that you have the same column in your application table? this Field must have the same name - CARDCODE (i.e. in Upper case)
THANKS,
now it working fine but it taks effect only after reloading data.
1. i'm login with an admin user
2. runing reload - all data is reloaded
3. i save the file
4. now im login with a regular user - only the premited data are displayed
5. now im login agin with admin, and i see only a part of the data (like the regular user)
i think the point is that "*" doesnt work for admin user
Star is *;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, DELARCODE
ADMIN, ADMIN, 1, *
USER, DEALER, 1, XXXX
];
Section Application;
I'm sure it will work if you leave it blank:
ADMIN, ADMIN, 1,
thanks, it works!
Explanation:
Star in Section Access doesn't mean "all" - it rather means "all listed in the records of the section access".