I am using Execute non query activity to insert or update data into a datatable. All data appears except for one column the data is not inserted or updated. I do not receive any errors from Ui Path. When I use the exact same activities in a single UiPath Project and not in my State Machine it works.
I let the values write out before the queries and there are all there. I copied the whole state machine in a new UiPath Project and it didnt work.
Has anyone experienced the same issues or knows about a reason for this?
Thanks a lot for your help!
Here the statements:
“INSERT INTO TABLE_NAME (VAR1,VAR2, VAR3) VALUES (’”+var1+"’,’"+var2+"’, ‘"+var3+"’) "
“UPDATE TABLE_NAME SET var1= '”+var1+"’ WHERE var2 = ‘"+var2+"’ AND var3= ‘"+var3+"’ "