Security implementation

[#1]

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

[#2]

Try to put the line "binary .... " as the first line in your script, before all SETs.

regards
Julian Scatamachia

[#3]

Hi Julian,

I've try it. It Works, thanks for your help.

regards

Gilles