Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Access Section syntax error

Dear experts,

   Recently I'm learning Qlikview by myself. Today when i practise Access Section, I found an error when i click the reload button while the hidden scrpit is editted.

   I just want to establish two members, one is admin and the other is user.  I click the reload after finishing coding.(I'm not sure whether this process is correct). and an error message occurred and told that:

2015-01-07_13-49-22.jpg

the chinese said that an syntax error occurred and 'From' is missing or at wrong place.

Could anyone help me on this issue~~

Many thanks and thanks in advance!!

br,

Lisen

Tags (2)
1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: Access Section syntax error

THIS WORKS

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, U1

    USER, USER2, U2

];

SECTION Application;

17 Replies
MVP
MVP

Re: Access Section syntax error

A semi colon is possibly missing. Try like:

Section Access;

Load

          *  ;   // this semi colon is required

// This extar load might not be required if there is no such modification to inline load

Load * Inline [

...

];

giakoum
Honored Contributor II

Re: Access Section syntax error

please copy your whole script here

Not applicable

Re: Access Section syntax error

OK, I'll try this method~

thanks very muchSmiley Happy

Not applicable

Re: Access Section syntax error

just a very simple code:

SECTION

Access;
load * inline[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1
USER, USER2, U2
]
;


Not applicable

Re: Access Section syntax error

I've tried this semi colon...but sadly it failed again...

but i'm still appreciate for your reply~ 

giakoum
Honored Contributor II

Re: Access Section syntax error

THIS WORKS

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, U1

    USER, USER2, U2

];

SECTION Application;

MVP
MVP

Re: Access Section syntax error

Try inserting a space between the keyword Inline and '[' like:

load * inline [

Not applicable

Re: Access Section syntax error

sorry man...it failed due to same error...

did i miss some script or some configuration is not correct?

giakoum
Honored Contributor II

Re: Access Section syntax error

this is the exact same code and it works in Qv11.20Sr1

Try it out

Community Browser