How to initialize variable with field value ?

[#1]

Hi everybody ,

I have an section access in my application  like this :

Load

ACCESS ,NAME , OMITGROUP

FROM myqvd.qvd ;

for any user , the field omitgroup have a diffrent value.

I'll like to initialize a variable with the value of this field when a user log in my application.
Is it possible ?

[oknotsen]

What do you actually want to achieve?

[marcus_sommer]

By section access be cautious and read the links here Section Access especially the Introductio very carefully.

Your example won't work because you could only use those fields which are specified for section access like:

Load

ACCESS, NTNAME , OMITGROUP

FROM myqvd.qvd where 1 = 1;

and it couldn't be an optimized qvd-load.

Your variable-issue isn't quite clear, do you mean something like:

varUser:

= osuser()

- Marcus

[jagan · Accepted solution]

HI,

Try like this

Section Access;

Load

ACCESS ,NAME , OMITGROUP

FROM myqvd.qvd ;

Section Application;

Test:

Load DISTINCT

OMITGROUP

FROM myqvd.qvd ;

Now in variable just use Only(OMITGROUP).

Regards,

Jagan.

[#5]

thank yuo , it work now