Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have to implement security on an application. I use this code.
Section Access;
SACCESS:
LOAD DISTINCT
ACCESS,
NTNAME,
USERID,
PASSWORD,
SHEET AS _SHEET_Intersect
FROM $(data)\$(dataCommon_rep)\QV_VisionClients_Security.xls (biff, embedded labels, table is User$);
Section Application;
Star is *;
Binary visionclient_scriptdata_step1.qvw;
SHEET_INTER:
LOAD distinct
SHEET as _SHEET_Intersect,
replace(SHEET,'[ALL]','*') as SHEET
FROM $(data)\$(dataCommon_rep)\QV_VisionClients_Security.xls (biff, embedded labels, table is User$);
SHEET:
LOAD SHEET,
SH01,
SH02,
SH03,
SH04,
SH05,
...
FROM $(data)\$(dataCommon_rep)\QV_VisionClients_Security.xls (biff, embedded labels, table is Sheet$);
It returns the following error :
Instruction inconnue
Binary visionclient_scriptdata_step1.qvw
Thanks for your help
Best regards
Gilles
Hi,
I think this could be related to the fact that you can use only one Binary statement in the script, and it has to be the very first statement as described in the QlikView Reference Manual on page 285 and 505:
"The
binary statement is used to load the access and data parts of a QlikView document. It does not load the layout information. Only one binary statement is allowed in the script and it can only be put as the first statement of a script."
"Binary load uses very special logic to read the data already processed once into QlikView in another QlikView document. The "unpacking" used requires a "clean slate" in memory which is the reason why a Binary statement must be the very first statement in the script. Therefore it is also impossible to use Binary more than once in a script."
Hi Gilles,
Could you try to put the "binary instruction" at the beginning of your script before the line of section access.
I think that this kind of expression have to be the first expression in a qlikview script.
In the manual ("QlikView Manual.pdf" french version), you coul read on page 552 that the Binary instruction have to be the really first line of a script.
I had the same error and i did this and now it's working.
Regards,
Arnaud DURQUETY