id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
306	Error in DBTableColumn?	imendez	danirus	"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"	defect	closed	normal		Database	head	normal	fixed