non-recognized types of fields in a query to MySql

[imendez]

TOL doesn´t recognize a "count" operation as a real type data.
If you compile:

Text qry ="
select count(*)
from
(
select 'hola'
) t";
Set s = DBTable(qry);
Real r = s[1][1];
Text t = s[1][1];

You find the following error message:

Warning: (Funcion DBTable) La consulta debería devolver un texto, una fecha o un
número en el campo 1
ERROR: Tipos incompatibles en Element (ó [ ] ): es de tipo Text, pero no de
tipo Real.
ERROR: r no se pudo crear.

[danirus]

Hi Iván,

I need some information about the Database, and also I need some time to
configure my Windows in my very-old Pentium III to try the code. By now, please
tell me which RDBMS are you using? (MyQSL/Oracle/DB2...), and which version?

In advance I can inform you that your code works good under gnu/Linux using both
MySQL drivers, Tol-ODBC and Tol-MySQL Direct. Last sentence returns an error,
but nothing unexpected, I mean, it's not possible to convert from Real to Text.

Please tell me that data about your RDBMS.
Cheers, Daniel

[imendez]

Now it works rigth. I think it could be related to bugs #294 and #295.

Regards.

[danirus]

This bug was already fixed.

* This bug has been marked as a duplicate of bug 295 *

[Víctor de Buen Remiro]

Due to problem could be extensible to other database engines, it has been added a new test to check it in all allowed engines

​http://cvs.tol-project.org/viewcvs.cgi/tol_tests/toldb/by_engine/common/Bugzilla/bug_000296

[Víctor de Buen Remiro]

This is not a duplicate of 294 but it's fixed long time ago

[Jorge]

(In [4537]) fixes #1503, refs #1022,#983,#300,#296, BIGINT is returned as SQL_C_CHAR then converted to Real