Unable to Insert Data into MYSQL Database

Help Activities
, ,
1

Hi all,
I am trying to insert data into MYSQL database using below query in a variable but the data is not uploading properly its shown as empty rows in DB. I have also passed the variables in parameters but don’t know why this happened.

“INSERT INTO RPA_FBL_UAT.Weekly_PDF_TABLE
(Job_ID, Cash and balances with treasury banks, Investments, Gross Advances, Provisions, Advances- net of provision,
Deposits and other accounts, File Date)
VALUES (@iDJOB, @cashbalanceotherbank, @Investmentsdata, @grossadvance, @Provisionsdata, @advancenetdata, @Depositsdata, @currentday);”

image
image754×335 13.2 KB

image
image782×83 2.64 KB

2

Hi @connect360

Replace “@value” with “?”

INSERT INTO RPA_FBL_UAT.Weekly_PDF_TABLE
(Job_ID, `Cash and balances with treasury banks`, Investments, `Gross Advances`, Provisions, `Advances- net of provision`,
`Deposits and other accounts`, `File Date`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?);

In the “Parameters” property of the “Execute Non-Query” activity, provide a List of objects containing the values for the parameters in the order they appear in the query.
Parameters: {iDJOB, cashbalanceotherbank, Investmentsdata, grossadvance, Provisionsdata, advancenetdata, Depositsdata, currentday}

3

Hi , I have tried it but it shown the below error

image

4

@connect360

Check where the values in variables are really getting passed…use lcoals panel to check it

cheers

5

I have assign the values manually.

image

6

@connect360

can you check from locals panel…

also is the assign done before running the query?

also are there multiple variables with same name used?

cheers

7

Assign is before running query and all variables have different name.

8

yes i have validate it manually as well all the variable and sequence in parameter is as per DB. Is that the below pattern is ok??

Query:
“INSERT Into RPA_FBL_UAT.Weekly_PDF_TABLE
(‘Job_ID’, ‘Cash And balances With treasury banks’, ‘Investments’, ‘Gross Advances’, ‘Provisions’, ‘Advances- net Of provision’,
‘Deposits And other accounts’, ‘File Date’)
VALUES (?, ?, ?, ?, ?, ?, ?, ?);”

Parameter:
{iDJOB, cashbalanceotherbank, Investmentsdata, grossadvance, Provisionsdata, advancenetdata, Depositsdata, currentday}

image

9

image

10

@connect360

Try:
INSERT INTO RPA_FBL_UAT.Weekly_PDF_TABLE
(Job_ID, [Cash And balances With treasury banks], Investments, [Gross Advances], Provisions, [Advances- net Of provision],
[Deposits And other accounts], [File Date])
VALUES (?, ?, ?, ?, ?, ?, ?, ?);

And change the parameters ti string(object)

11

How to select string of object parameter type?

Throwing the same error

Run query: No mapping exists from object type System.String to a known managed provider native type.

image

12

Sorry, its an array of object

13

again same error can you please develop a process with this type of working.

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.