Hi,
I’m relatively new to Uipath, and would need some help working with SQL DBs.
Currently I have a problem in loading on DB, a table collected from a scraping, at the beginning of the flow.
my flow collects table DT1, for convenience I have extracted it on Excel. Elenco.xlsx (8,4 KB)
This table must be overwritten every RUN, so the data can be overwritten every day.
I have to insert the values of the first three columns, on the DB I previously created.
Here is my flow, which gives a syntax error in the UPDATE Query. Bot2.xaml (273,0 KB)
UPDATE DT1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NumberSort in descending order =‘0410040094’’ at line 1",
OK. Resolved.
Valuable help !!
I redid the tests on SQL Client … fixed the query … now it’s ok !!
Thanks so much … really … I was stuck for a few days
I am very inexperienced.
Thanks!
Aaron
UHm… sorry…
I sang victory too soon.
The query inserted (rightly) only the last row of the extracted table.
Actually, I need the whole table on DB to be overwritten with the table collected by the scraping.
Currently consisting of 3 rows … and 3 columns.