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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Insert record into database script help needed

Level 3
Level 3

Please review the following, I am trying to correct the syntax, yet, having no success.

Database.ExecSQL("INSERT INTO CRF (TodayDate, SubmittedBy, Region, Market, DoorDepartment, ProjectEvent, ProjectType, RenderingsDue, FinalArtworkDue, EventDate, EventDays) VALUES (""TodayDate.rawValue" + "SubmittedBy.rawValue" + "Region.rawValue" + "Market.rawValue" + "DoorDepartment.rawValue" + "ProjectEvent.rawValue" + "ProjectType.rawValue" + "RenderingsDue.rawValue" + "FinalArtworkDue.rawValue" + "EventDate.rawValue" + "EventDays.rawValue"");")

TodayDate.rawValue = ""; // clear after inserting comment

The above script is an action on a button from Stefan Cameron's tutorial on using SQL to insert a new record to a database.

Where have I gone wrong with this script?

0 Replies