Jump to content
Sign in to follow this  
DikkeHenk

Global variable in a calculation

Recommended Posts

Hi,

I am trying to set a Global variable with a Let statement in a calculation field. The variable is set when I assign it to hardcoded DATA but when I assign it to a field the Global variable stays empty. The calculation-field is supposed not to return anything but I also tried to return with the Gobal Variable ($$_Var) and that does work either. The calculation-field and the referenced field in the 'Let Statement' are in the same table.

Need Help

Henk

Calculation field:

Let (

$$_Var = _Field (does not work)

;

""

)

or

Let (

$$_Var = "blabla" (works)

;

""

)

Share this post


Link to post
Share on other sites

If the calc is stored then the value of variable should change when the value in _Field is committed. If the calc field is unstored, then it should display the change.

Are you refreshing the dataviewer?

Share this post


Link to post
Share on other sites

Thanks for replying,

The calculation field is a Matt Petrowsky technique. I am using it to calculate wich tab I am on. It is an unstored calculation (8 repetitions) wich calculates the (Get repetition) the repetition-nr. Each field-repetition is on a seperate tab.

Within the same calculation (Let function) I also want to load a Global Variable with the contents of a field so when you enter a Tab the Global variable is allready set for further ussage. The fields are in the frontend table (Interface with only one record) of a database-sys.

When I click on the layout (commit) the Global Var stays empty also when I refresh the data viewer. With hardcoded data it works OK I do not even have to refresh the dataviewer.

Henk

Share this post


Link to post
Share on other sites

If it's a repeating calculation, you need to reference a non-repeating field using the Extend() function. I am only guessing here, since your description is still rather vague.

Share this post


Link to post
Share on other sites

Thank YOU Veteran,

Problem solved,

Nothing wrong with your guessing. Sorry for the vague description but I am not writing in my native language.

The problem took me one day and a half before I turned to the forum. Then it was solved in half an hour.

Thank you for that

Henk

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.