Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

^ or Power() in update data expression

Avatar

Avatar
Validate 1
Level 1
Idde1969
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Idde1969
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Idde1969
Level 1

15-02-2019

Hi.

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

Best regards,

Martin

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

15-02-2019

Hi,

Follow this guide:

Thanks,

-Jon

Answers (0)