1 Reply Latest reply: Aug 8, 2012 4:41 AM by Wojciech Parzyszek RSS

    section access rpoblem

    Stefano Peroni

      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

        • Re: section access rpoblem

          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

          ];