section access

[denis115]

Hello ! I've got a problem with section access. I have two lists : PRODNAME and REGION. While I execute this code

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODNAME
ADMIN, user1,*
USER, user2,HAYAT
USER, user3,EVYAP
USER, user4,KALINA
USER, user5,COSMETICA
USER, user6,CONSTRMAT
USER,user7,DEFAULT
USER, user8,NEVCOSMET
USER, user9,FOOD
USER, user10,TRICOT
USER, user11,PAPER


];
Section Application;

It works great but when I change instead of PRODNAME to REGION it doesn't want to open if I enter as user.

What I need to change?

Thank you !

[avinashelite]

1.Upper : In Section Access/application  all the columns need to be in upper case ...so upper function does that ...

2.PurgeChar: if you see the region column data in section access it has only country names but your data set in the inline has number with it

i.e. 09 Germany and in the section column it is GERMANY so this will eliminate the numbers and dot in the data so that data match with the section access table

[denis115]

thanks!

[avinashelite]

Don't forget to mark the helpful answers !!