Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I've created the following section access:
USERACCESS:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, FIELD1, FIELD2
ADMIN, ADMIN,ADMIN, ,
USER, USER1, U1, 9001,
];
Concatenate
LOAD 'USER' AS ACCESS,
UPPER(USERCODE) as USERID,
UPPER(USERPASSWORD) as PASSWORD,
UPPER(cod1) as FIELD1,
UPPER(cod2) as FIELD2
RESIDENT mytable;
// CREAZIONE SECTION ACCESS
SECTION ACCESS;
Load *
Resident USERACCESS;
After the loading, as ADMIN, I see everything. If I close and open the document, as ADMIN I don't see anything. If I open the document as USER1, I see all the information concerning this user. What I'm doing wrong ?
Help please
Thanks in advance
what is the reason you load :
// CREAZIONE SECTION ACCESS
SECTION ACCESS;
Load *
Resident USERACCESS;
???
try this : -------------------------------------------
SECTION ACCESS;
USERACCESS:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, FIELD1, FIELD2
ADMIN, ADMIN,ADMIN,*,
USER, USER, USER, 1111,2222
];
Concatenate
LOAD 'USER' AS ACCESS,
UPPER(USERCODE) as USERID,
UPPER(USERPASSWORD) as PASSWORD,
UPPER(cod1) as FIELD1,
UPPER(cod2) as FIELD2
RESIDENT mytable;
section Application;
LOAD * INLINE [
FIELD1, FIELD2
1, 2
11, 22
111, 222
1111, 2222
];
or this: ---------------------------------------------------------
USERACCESS:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, FIELD1, FIELD2
ADMIN, ADMIN,ADMIN,*,
USER, USER, USER, 1111,2222
];
Concatenate
LOAD 'USER' AS ACCESS,
UPPER(USERCODE) as USERID,
UPPER(USERPASSWORD) as PASSWORD,
UPPER(cod1) as FIELD1,
UPPER(cod2) as FIELD2
RESIDENT mytable;
//CREAZIONE SECTION ACCESS
SECTION ACCESS;
Load *
Resident USERACCESS;
section Application;
LOAD * INLINE [
FIELD1, FIELD2
1, 2
11, 22
111, 222
1111, 2222
];