2 Replies Latest reply: Jan 20, 2014 8:52 AM by Sampath Botla RSS

    Section Access SQL

      Hello

       

       

      Initially sorry for the language, but I am Brazilian.

       

       

      I'm testing a QV with Section Access which works normally if I do the load through Load InLine, but when I load the data from Section Access via SQL it does not open, saying I have no access to the file.

       

       

      Have I made sure that the SQL statement returns the same data EXACTLY Load InLine command. Has anyone gone through this problem?

       

       

      Below is the example I'm testing:

       

      Dont Work

      SECTION Access;

       

       

      SQL

        Select 'ADMIN' as ACCESS,

                  'Administrator' as NTNAME,

                  '1' as LINK;

       

      Work

      SECTION Access;

      LOAD * INLINE [

          ACCESS, NTNAME, LINK

          ADMIN, Administrator, 1

      ];

       

      Help-me Please!