Geek asks and answers

Undefined Replace function in expression

I have a VB.Net application. I connect it to the MS Access database. Now I have to fulfill the request. My request:Update table1 set field1=replace(field1,'|','"')

This query seems to work fine with the Access database query analyzer, but when I do the same form of VB.Net code, it gives me the error message "Undefined function" Replace "in the expression"

I am using the OLEDB link and team. I use the function "executononquery".

Can anyone help me?

+3
source share
2 answers

, Access VB.Net, Access. Jet. , Access (, ), Jet.

- Iif, Instr .. (). , , , .

+4

.

Provider=Microsoft.ACE.OLEDB.12.0

# :

cmd.CommandText =
    "UPDATE table1 SET field1 = Replace(field1, '|', '\"')";
cmd.ExecuteNonQuery();

, Replace() OLEDB Jet (, , ACE), Access 2010 .

+3

More articles:


All Articles