String constants must be in quote .Error Execute Query

Hello.
I have a problem performing a Select.
I am working with Oracle, the Select, insert, Update and Delete connection works for me. I have the problem when making a select and passing a variable to it, it gives me an error, I put a screenshot and the .xaml
I have looked at various links on the forum, but it does not work for me.
The query is very simple:

"Select *

from archivos2 a

where a.EMPLEADO =’“strEmpleado”’"


SELECT.xaml (6,5 KB)

Hi @Aguirre

Can you please remove the blank lines in between and try again…

Thanks

1 Like

Thank you very much, I’ve been looking for the problem for a long time and I didn’t expect it to be so simple.
So it already works without problems:

“Select * from coan_archivos2 a where a.EMPLEADO =’”+strEmpleado+"’"

@Aguirre I also doing these kind of mistakes often but we learn from mistakes only ,cheers :grinning:

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