Insert Variable into Database

Hi all,

I am a newbie in the UiPath world. Currently, I am trying to store a “Get Text” variable (varDate) to insert into my database under the column (Start_Date).

I set the SQL to “Insert into FP_WEEKLY_PRICE (AVERAGE, START_DATE, PRICE) VALUES(‘CNG-HH’,@varDate, 2.38)” to include the @varDate and adjusted the parameters to the below.

What am I doing wrong here?

image

Additional images

Additional images

Additional images

Insert into FP_WEEKLY_PRICE (AVERAGE, START_DATE, PRICE) VALUES(‘CNG-HH’,’"+varDate+"’, 2.38)

Thank you for your quick response Bcorrea, you are on to something! I am getting a new error now.

image

i think this is not very much an UiPath error, but seems like some of the parameters has the wrong value, check your data extraction, where this “19” value is coming from? Maybe clean that apostrophe char from it…