teixeira
Well-known member
Hi all,
I have a query to execute against an access database and is strange, because inside Access querys directly it executes perfectly, but inside my code its not executes, giving an error about the REPLACE keyword.The sql statement is the following:
SELECT CODIGO,CODBARRA FROM ARTIGOS WHERE REPLACE(CODIGO,.,)<>CODBARRA
Note: Im using Microsoft.Jet.OLEDB.4.0 as my Data Provider. with C# 2005
If anyone can help me about this, ill be very thankfull
Rgds
Tiago Teixeira
I have a query to execute against an access database and is strange, because inside Access querys directly it executes perfectly, but inside my code its not executes, giving an error about the REPLACE keyword.The sql statement is the following:
SELECT CODIGO,CODBARRA FROM ARTIGOS WHERE REPLACE(CODIGO,.,)<>CODBARRA
Note: Im using Microsoft.Jet.OLEDB.4.0 as my Data Provider. with C# 2005
If anyone can help me about this, ill be very thankfull
Rgds
Tiago Teixeira