I have a little problem, I have a table called Travis with recipe data in it. I have a recipe select pull down list that is connected to the SQL database. When I have a recipe selected I have a button I want to push that will load data from the selected row in to tags in my PLC. I am getting an error:
Parse error for event handler “actionPerformed” SyntaxError: (“no viable alternative at input ‘Density’”, (’ ', 4, 49, ‘“RecipeTags/Density” = system.db.runQuery(select Density from Travis where RecipeName = ‘recipeselected’)\n’))
My code is this:
# Set row that I want to pull data from recipeselected = event.source.parent.getComponent('Recipe Select').selectedStringValue # Run Query to grab data and set it to an memory tag "RecipeTags/Density" = system.db.runQuery(select Density from Travis where RecipeName = 'recipeselected') # Set Memory Tag equal to my PLC Tag "Controller:Global/Ingredient/Ingredient_0_" = "RecipeTags/Density"
I am not sure why it is giving me this error when looking up a value. this is the same call as my binding on another screen. Any help would be helpful.