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

Query: CREATE TABLE...could not be executed.

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

16-01-2015

Symptom

Adding data in a Query and changing the alias results in a red blinking outline and this error logged to the journal:

CREATE TABLE wkfnnnn could not be executed.jpg

Cause

Alias for additional data has a space in it, e.g. purchase amount instead of purchaseAmount or @purchaseAmount.

Fix

Get rid of spaces in the alias name and by convention use camel case (lowercase first word, uppercase inner words.) Using the '@' syntax will allow you to reference the additional data in the same way as attributes from the data model in JavaScript.

Preventative

Alias names are used as the attribute name when inserting values into the temporary worktable so be sure they follow attribute naming rules.