Update a DB using Custom SQL
Can you let me know what I am doing wrong here? thanks!
- 3 replies
- DDaniel Horton @daniel.horton
Before we go any further - are you aware that the Select state running here would be used to optionally trigger an Insert or Update based upon whether a return value is found? I'm just curious as to whether you are attempting to pull a single value or value(s) back for further use in your Automation because if you are then you need to reference the following action type instead - https://support.thinkautomation.com/#lookup-from-a-database
Okay then looking at your current setup the main issue appears to be within the Parameter in the lower half of your window. For this it is recommended to click on the Name field and you'll notice a drop down selector appears for the field name. You can then cycle between all of the Parameters you will have declared. They begin with @ values within here. This is my example and it works successfully against my small test table I made:
If you accidentally add additional lines (as I did) then you can right click and select Delete on the row.