Executing SQL query using UIPath

[amithvs (Amyth)]

Hi Guys. Need your help here!!
I am having two columns which has to be multiplied and the result should be stored in a new column.
I used
“Connect”
“Executequery”

When I use UPDATE Sheet1$ SET Totalcost=Units*CostofProduction I am getting error

Compiler error encountered while executing expression UPDATE Sheet1$ SET Totalcost=Units*CostofProduction. end of expression expected.

sample.xaml (15.2 KB)

I am here attaching the workflow that I did till now, expecting your valuable suggestions. Thanx in advance guys…

my DB
units costofproduction totalcost
30 1567 NULL
15 10787 NULL
12 10982 NULL

[Lucas.Pimenta]

Hello!

Have you tried to add " on your expression?

Like: “update Sheet1$ SET Totalcost=Units*CostofProduction;”

Hope It Helps

Regards,

[amithvs (Amyth)]

I already got it. Anyway tanx a lot…