what's wrong with this script

[ali_hijazi]

Section Access;

LOAD  Distinct

     USER_LOGIN

FROM

QVDS\SILK_USER_PROJECT_DW.qvd

(qvd);

SECURITY:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, ALI, HIJAZI, *

];

Concatenate(SECURITY)

LOAD 'ADMIN' AS ACCESS,'*' AS USERID, '*' AS PASSWORD,'lb\' & USER_LOGIN AS NTNAME

Resident TEMP_SECURITY;

DROP Table TEMP_SECURITY;

Section Application;

I'm getting an error that says general script error

please advise

[robert_mika]

One error is here:

LOAD 'ADMIN' AS ACCESS

you do not need the single quote

[#3]

Can you show the error?

[Peter_Cammaert]

I think QlikView simply cannot find the TEMP_SECURITY table because apparently you forgot to give the top table a name...

After Section Access; add this line:

TEMP_SECURITY:

[ali_hijazi]

NO i have to put this

it doesn't work either without single quotes

[buzzy996]

are u having/defined this table "TEMP_SECURITY"?