topic security y qvd in QlikView

security y qvd

carlos13 — Mon, 21 Nov 2011 19:15:25 GMT

I can not assign my safety from a QVD

How I can do? try to do this:

Section Access;

Directory;

LOAD [USERID],

[PASSWORD],

[ACCESS],

COD_MATRIZ_COMPANIA,

VIP

FROM

TB_SEGURIDAD.qvd

(qvd);

Section Application;

Star is *;

and does not work

security y qvd

Mon, 21 Nov 2011 20:20:18 GMT

Carlos13, Exists TB_SEGURIDAD:qvd?

However, try to do this: "Directory:" replace it to "Directory;"

Section Access;

Directory:

LOAD [USERID],

[PASSWORD],

[ACCESS],

COD_MATRIZ_COMPANIA,

VIP

FROM TB_SEGURIDAD.qvd (qvd);

Section Application;

Star is *;

Regards.

security y qvd

carlos13 — Mon, 21 Nov 2011 20:38:46 GMT

thanks,

Are "Directory;" from the beginning and does not work

security y qvd

Wed, 30 Nov 2011 13:11:33 GMT

Seguridad:

LOAD Upper(Trim([ACCESS])) AS ACCESS,

USERID,

PASSWORD

FROM

(biff, embedded labels, table is Hoja1$);

STORE Seguridad into Seguridad.qvd (qvd);

drop Table Seguridad;

STAR IS *;

Section Access;

load

ACCESS,

USERID,

PASSWORD

from Seguridad.qvd (qvd)

Where 1=1;

SECTION Application;