Excellent video. But while updating, I get Column Type mismatch error. The ID column is integer in DB and in excel earlier it was general and later I changed it to number but same issue. Please help.
Sir, When I try to Insert data for a single row, it's fine and successful. Whereas when I try to Insert the data for multiple rows in a data table, it was always throwing an error like : "SQL Command not properly ended". Query: "insert into employee values(100,'Nanda','Pune',50000),(2,'Suresh','Banagalore',100000),(1,'Lavanya','Hyderabad',60000),(4,'Gopi','Chennai',70000)" May I please know how to use this query in uipath? Thank you.
@@MukeshKala Sir, It's working fine in SQL editor, I was facing error from uipath end. I've tried this query using Run Query and Run Command Activities. It was showing the same error like "SQL Command not properly ended".
Hi this is yaswanth i got this message while running "message": "Bulk update: The provided columns in the DataTable do not match the column data types in the database.",
@@toshi_garg In the Property panel of "Bulk Update" there is an option "Bulk/Batch Update", By default it is checked, uncheck it and then run the process.
17:51 - liked the video and understand the concept :) Great job, been using this series of videos to setup automation at work. Thanks!!
Glad it was helpful!
you are doing grt work for us just keep it up sir
I will , Thank you 😊
thanks for the detailed explanation
You're welcome!
"message": "Bulk update: The provided columns in the DataTable do not match the column data types in the database.",
You need to make sure that columns name match , even a extra space in names can also cause this to fail
@@MukeshKala My column names are matching and there is same space between them but my column data type is string and it shows an object
Excellent video. But while updating, I get Column Type mismatch error. The ID column is integer in DB and in excel earlier it was general and later I changed it to number but same issue. Please help.
A good way to do that is - insert a row in database, copy the row from database and paste in excel , add more rows in excel and this become your input
Sir,
When I try to Insert data for a single row, it's fine and successful. Whereas when I try to Insert the data for multiple rows in a data table, it was always throwing an error like : "SQL Command not properly ended".
Query:
"insert into employee values(100,'Nanda','Pune',50000),(2,'Suresh','Banagalore',100000),(1,'Lavanya','Hyderabad',60000),(4,'Gopi','Chennai',70000)"
May I please know how to use this query in uipath?
Thank you.
Seems like a Syntax Error - Execute the same in the SQL Editor , Correct the Syntax and then re try
@@MukeshKala Sir, It's working fine in SQL editor, I was facing error from uipath end.
I've tried this query using Run Query and Run Command Activities. It was showing the same error like "SQL Command not properly ended".
@@PraveenKumarG-s2r add alter command
Any video we get in hindi this week sir?
Yes , Pdf automation with UiPath
Hi this is yaswanth i got this message while running
"message": "Bulk update: The provided columns in the DataTable do not match the column data types in the database.",
You have a data type mismatch between your database table and the table you are trying to insert
How did you resolve this error? I am also getting the same error and tried to get through it but no help.
@@toshi_garg In the Property panel of "Bulk Update" there is an option "Bulk/Batch Update", By default it is checked, uncheck it and then run the process.
It gives incorrect syntax near the keyword '....'.