Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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