Section Access SQL

[#1]

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!

[#2]

Discovered!

When performing the load via SQL users need to convert user names to uppercase, with the function UPPER

Descobri!!!

Ao realizar a carga dos usuários via SQL é preciso converter o nome dos usuários para letras maiusculas, com a função UPPER

[#3]

Hi Anderson,

                  You must change them to upper case to work in section access, because section access allows only uppercase data as per qlikview standards.

thank you.