Query don´t run in Tol

[Iván Robles]

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

[danirus]

Hi,

Please, send me (privately) a short description of the tables needed to execute the code. I'll be able to give it a try next week. Now from my place I have not access to any Oracle RDBMS.

By the way, did you try with slightly different queries? I mean, just removing the quotes or something else? It would be better if you could provide in advance a bit more accuracy in what it works and what it doesn't, just to dismiss some possibilities.

Thanks,
Daniel