Unable to dynamically update data into sql database

Help Activities
, ,
1

Hi All,

I am trying to update data dynamically into database with the help of parameters but its not working .Also its not giving any error.

Here I am trying to read data from web page with help of get text elements and storing the output of the get text into variables.
These are the 4 variable

Case_Log_status
Case_Log_status
Solution_Provided
Remarks

Also query used to update the data is as follows

“UPDATE dbo.t_Dell_Vendor SET Case_Log_Date = @Case_Log_Date,Case_Log_status = @Case_Log_status,Solution_Provided = @Solution_Provided, Remarks = @Remarks WHERE Vendor_Ticket_Number = @Vendor_Ticket_Number”

help is much appreciated
Thanks & Regards

2

Hello @siddhi.kamble . Welcome to Uipath Commubity
Try this query

“UPDATE dbo.t_Dell_Vendor SET Case_Log_Date = ‘“+Case_Log_Date+”’,Case_Log_status = ‘“+Case_Log_status”’,Solution_Provided = ‘“+Solution_Provided+”’, Remarks = ‘“+Remarks+”’ WHERE Vendor_Ticket_Number = ‘“+Vendor_Ticket_Number+”’”

“UPDATE dbo.t_Dell_Vendor SET Case_Log_Date = ‘“+Case_Log_Date+”’,Case_Log_status = ‘“+Case_Log_status”’,Solution_Provided = ‘“+Solution_Provided+”’, Remarks = ‘“+Remarks+”’ WHERE Vendor_Ticket_Number = ‘“+Vendor_Ticket_Number+”’”
3

Hey! Welcome to community!

Try this:

"Update dbo.t_Dell_Vendor SET Case_Log_status =" +Case_Log_status+",Case_Log_status ="+Case_Log_status+",Solution_Provided ="+Solution_Provided+",Remarks ="+Remarks+"WHERE"+ "Vendor_Ticket_Number =" +Vendor_Ticket_Number

Regards,
NaNi

4

Thank you for the efforts

Hi
@Gokul_Jayakumar ,
i tried your query but its giving error as : Execute Non Query: Incorrect syntax near ‘‘’.

Query used
“UPDATE dbo.t_Dell_Vendor SET Case_Log_Date = ‘“+Case_Log_Date+”’,Case_Log_status = ‘“+Case_Log_status+”’,Solution_Provided = ‘“+Solution_Provided+”’, Remarks = ‘“+Remarks+”’ WHERE Vendor_Ticket_Number = ‘“+Vendor_Ticket_Number+”’”

Hi @THIRU_NANI ,
i also tried your query but this is also giving me error : Execute Non Query: Incorrect syntax near the keyword ‘Order’.

Query used
“Update dbo.t_Dell_Vendor SET Case_Log_status =” +Case_Log_status+“,Case_Log_status =”+Case_Log_status+“,Solution_Provided =”+Solution_Provided+“,Remarks =”+Remarks+“WHERE”+ “Vendor_Ticket_Number =” +Vendor_Ticket_Number+“”

5

Anyone has idea about the issue ?