Insert Variable into Database

[aaronpayne]

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?

[aaronpayne]

Additional images

[aaronpayne]

Additional images

[aaronpayne]

Additional images

[bcorrea (Bruno Correa)]

@aaronpayne

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

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

[aaronpayne]

@bcorrea

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.

[bcorrea (Bruno Correa)]

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…