I want to update SQL tab dynamically. The tab contain columns “numCin” and “statusBCT”
So I extracted the tab into data table, automated the process, and after completing the process,
I want to update column “StatusBCT” = OK per line.
Here is the syntax i put for the query but does not work:
“UPDATE TLFTestTable SET [statusBCT]=‘OK’ WHERE numCin=’+Cin+’”
What’s the solution? thanks,