Fox Code:Inclusion of field which cant be used as field to be changed or in conditions

[Former Member]

Hi Folks,

I have a field and value for that field is made by user selection.

Now, i want to include that field in filter used by the planning function.

But my question is could i include that field directly in filter using the same variable thats used in input layout and modifying the fox code by passing value to the field by this statement:

Let the field added be X.

X = VARC(VARIABLE NAME).

Kindly advice.

Thanks

[Former Member]

As per my understanding you want to know if you can restrict the field value to a variable used in input layout in filter and then you want to use the same in fox code using VARC.

You can restrict same variable in filter and once restricted fox code will be able to amend the data for all the values of a variable at one go.However if you want to pick only few values for variable based on input and perform manipulation then I would suggest to use VARV,VARC and VARI .

Hope it helps.

[cornelia_lezoch]

Hi Kitu,

the code on how to read variable values in fox is different than what you stated.

you need to define first a local variable

data local type xxx. (local is an individual name, xxx is the info object name)

then you need to fill the local variable with the value from your bex variable.

local = varv (yyy). (yyy is the technical name of your bex variable).

regards

Cornelia

[Anand71]

Hello,

Yes, you can use same variable in the Input layout and filter of the plannning function. Read the variable to modify the Fox formula.

Regards,

Anand Kumar