id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
358	Strange behaviour when downloading series from database.	jimarin	Víctor de Buen Remiro	"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"	defect	closed	normal		DataBase	head	major	later