Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

THIS WORKS

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, U1

    USER, USER2, U2

];

SECTION Application;

View solution in original post

17 Replies
tresesco
MVP
MVP

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
Partner - Master II
Partner - Master II

please copy your whole script here

Not applicable
Author

OK, I'll try this method~

thanks very much:)

Not applicable
Author

just a very simple code:

SECTION

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


Not applicable
Author

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

but i'm still appreciate for your reply~ 

giakoum
Partner - Master II
Partner - Master II

THIS WORKS

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, U1

    USER, USER2, U2

];

SECTION Application;

tresesco
MVP
MVP

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

load * inline [

Not applicable
Author

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

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

giakoum
Partner - Master II
Partner - Master II

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

Try it out