id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
571	Query don´t run in Tol	Iván Robles	Jorge	"Good afternoon,

  when I run the following code in Tol , for a BBDD oracle

Real DBOpen(ODBCTeleSPFat,UserTeleSPFat,PWTeleSPFat);
Text qry = ""SELECT
  CASE
    WHEN cf LIKE '%\%%' escape '\\""+""'  THEN 3100000002
  ELSE 1 END AS conceito
FROM 
  (SELECT 'A' AS CF FROM DUAL)B;
"";
Set DBTable(qry);

Real DBClose(ODBCTeleSPFat);

I have the following error:

ERROR: [8] La consulta SQL ha fallado:
SELECT
  CASE
    WHEN cf LIKE '%\%%' escape '\'  THEN 3100000002
  ELSE 1 END AS conceito
FROM 
  (SELECT 'A' AS CF FROM DUAL)B;


ERROR: [9] (Funcion DBTable) No se puede abrir la consulta a la base de datos :
SELECT
  CASE
    WHEN cf LIKE '%\%%' escape '\'  THEN 3100000002
  ELSE 1 END AS conceito
FROM 
  (SELECT 'A' AS CF FROM DUAL)B;

The BBDD is open correctly, but the query don´t run in Tol.The query is on DUAL de ORACLE, can run on any BBDD Oracle. The query run correctly in BBDD Oracle, but don´t in Tol.

Thanks"	defect	assigned	highest		DataBase	head	blocker