Dosen't work with null

[mdiaz]

DBSeriesColumn dosen't work. Try to run this code, C1 takes the value of NULL.

Text Query.001 =
"
select 'c1' as id_ser, convert(datetime, '20080101', 120) as id_date, 3 UNION
select 'c1' as id_ser, convert(datetime, '20080102', 120) as id_date, 2 UNION
select 'c1' as id_ser, convert(datetime, '20080103', 120) as id_date, 1 UNION
select NULL as id_ser, convert(datetime, '20080101', 120) as id_date, 8 UNION
select NULL as id_ser, convert(datetime, '20080102', 120) as id_date, 7 UNION
select NULL as id_ser, convert(datetime, '20080103', 120) as id_date, 6
order by 1, 2
";
Set XXXXXXX.001 = DBSeriesColumn(Query.001, C, 0);

[Jorge]

Dani, can you check this bug report?

[danirus]

Seems to be a problem not only with DBSeriesColumn but with the underlaying DB functions as well. I accept the bug and give you here some news as soon as possible.

[danirus]

As far as I can tell you, there's nothing wrong apart from what I fixed in DBTestTypes, the function in charge of column type validation. What I fixed there was something that fails in PostgreSQL, but seems to work well under other RDMBS, like -maybe- SQL Server (not said in your report, but I suppose so).

Please Jorge, could you produce a new Tol package for WinXP with this patch?

Let's see if this fixes the problem, but I'm almost sure it doesn't. At least I can ensure you that this bug is not a problem of DBSeriesColumn function. I rather encourage you to improve the query syntax, the problem might be there.