Strange behaviour when downloading series from database.

[jimarin]

Hi !

when working with Tol cvs snapshot version corresponding to 2006 02 20 I have a
problem (tol abruptly ends) when trying to get a time series from the database.

The code I use:

Serie ToGetSerie3Od(Text ArName, Text ArDating, Real ArDefault)
{

Text ThQuery = "

SELECT

valueDate,
value

FROM

CNOOutputData

WHERE

Output='" + ArName + "'

ORDER BY

valueDate

";

Set ThSet =

DBSeries(ThQuery, TimeSet Eval("TimeSet " + ArDating),

Set SetOfText(ArName),
Set SetOfText(""), ArDefault

);

Serie If(Card(ThSet)!=0, ThSet[1],

CalInd(W, TimeSet Eval("TimeSet " + ArDating))

)

};

Real DBOpen("nordic", "bayes", "bayes");

Awa Coc.
Serie Awa_Tot_Coc_Swe_Poi_Wd7 =

ToGetSerie3Od("Awa_Tot_Coc_Swe_Poi_Wd7", "WD(7)", Real ?);

Real DBClose("nordic");

I can provide with more data on request so as to help reproduce this problem.

The Tol cvs snapshot corresponding to 2006 01 30 does not have any problem
executing this code.

Cheers.

jima

[Víctor de Buen Remiro]

We are working about this bug
Thanks to report it

[Víctor de Buen Remiro]

Error has been detected but now I can´t to solve this.
You can avoid creating

TimeSet CtSunday = WD(7);

and replacing

ToGetSerie3Od("Awa_Tot_Coc_Swe_Poi_Wd7", "WD(7)", Real ?);

by

ToGetSerie3Od("Awa_Tot_Coc_Swe_Poi_Wd7", "CtSunday", Real ?);