I am trying to update a field with data using either ^ or the Power() funtion.
Floor(Random() * 2 ^ $(vars/@varNoOfGroups))
Genertates a GUI error and
Floor(Random() * Power(2, $(vars/@varNoOfGroups)))
Generates an error in the Journal
2019-02-15 10:54:12 writer XTK-170016 You are not authorized to use SQL expressions. 'Power' cannot be processed.
Any clue on how to solve this. Tried to add the named right SQL SCRIPT EXECUTION to my user
Solved! Go to Solution.