SQL returned type is not readable

[Víctor de Buen Remiro]

Hello,

When you run this TOL code with SQL embebed code

Matrix DBMatrix("

select

case

when 'any thing' is null then 0
when locate('another thing', 'any thing')=0 then 0

else 1

end

");

a 0x0 matrix is created and a TOL warning is sended to the user

Warning: [1] (Funcion DBMatrix) La consulta debería devolver un Real en el campo
1

My DB server is MySQL. Using MySql Browser with the query

select

case

when 'any thing' is null then 0
when locate('another thing', 'any thing')=0 then 0

else 1

end

I obtain a data set with just one row and one field containing the number 0.

Thanks

[Víctor de Buen Remiro]

Hello again

This TOL-SQL query without <is null> comparisson is all right

Matrix DBMatrix("

select

case

when locate('another thing', 'any thing')=0 then 0
else 1

end

");

[Jorge]

SQLDescribeCol should also consider SQL_SUCCESS_WITH_INFO as a valid return code.