Mysql query "Undefined function 'replace' in expression"

answered

#1

Hi there, when I run the following Mysql query
"
Update [Sheet1$]
Set url =replace(url,’//www’,‘www’)
"
I get : Execute query : Undefined function ‘replace’ in expression.

Whats the correct syntax ?

I am using Microsoft.ACE.OLEDB.12.0.

Since Uipath is 32-bit, I am using 32bit Microsoft.ACE.OLEDB.12.0. from office 2007. I also have 64bit Winautomation installed on the same machine with 64 bit Microsoft.ACE.OLEDB.12.0 for office 2010 and it works fine with mysql replace function.

I think the problem is , that uipath sees replace as a VB function and not Mysql function.

Thanks


Undefined function 'replace' in expression in execute Query
#2

I have solved the issue by upgrading to Microsoft Access Database Engine 2010 Redistributable from https://www.microsoft.com/en-au/download/details.aspx?id=13255 .