Error in DBTableColumn?

[imendez]

Hi,

in the DBTbaleColumn function help, we can read:

"

Además, mientras que los campos índice pueden ser de cualquier tipo, los

campos prefijo deben ser de tipo texto y el resto de tipo numérico.
".

However, the working of this function is just the opposite: TOL doesn´t allow a
numerical type field in the third group of fields. In the following example:

Text qry =
"
select setinput, output, 1
from ezcoutputsetinput
order by setinput, output
";
Set tc = DBTableColumn(qry, 1, 1, 1, "_", 0);

TOL returns:

Warning: (Funcion DBTableColumn) La consulta debe devolver un número en el campo 3

and the set "tc" has no elements. However, with the code:

Text qry2 =
"
select 1 as index_,

'a' as prefix,
3 as data

from dual
order by index_, prefix
";
Set tc2 = DBTableColumn(qry2, 1, 1, 1, "_", 0);

there isn´t any error message, and I don´t know why.

Regards

[danirus]

Hi Iván,

Sorry for answering so late.
This bug is quite related with the #537. Indeed I'd answer you in the same way as there, kindly asking you for a comprehensive description of what all you Tol Users really expect from this function, with a good set of examples to build a test suite.

Actually, this function seems to be more than a function, it has 512 lines of code, what is more close to be a module by itself. This huge amount of code reveals at least a misunderstand complexity that could be split in several other functions. First of all we have to know exactly what it should do.

Thanks for your understanding.
Hope to read from you soon.
D