Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.