id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
272	DBSeries returns no named series	César Pérez Álvarez	danirus	"If we try this code
-------------------------------------------------------------------------------------------------
Real DBOpen(""mydatabase"", ""myuser"", ""mypassword"");
Set mySet = DBSeries(""
select cast(id_date as datetime) as id_date, value
from
(
select '2003-01-01' as id_date, 1 as value union
select '2003-01-02' as id_date, 1 as value union
select '2003-01-03' as id_date, 1 as value union
select '2003-01-04' as id_date, 1 as value union
select '2003-01-05' as id_date, 1 as value union
select '2003-01-06' as id_date, 1 as value union
select '2003-01-07' as id_date, 1 as value union
select '2003-01-08' as id_date, 1 as value union
select '2003-01-09' as id_date, 1 as value union
select '2003-01-10' as id_date, 1 as value
) DATA
order by id_date"", Diario, SetOfText(""MySerie""));
Real DBClose(""mydatabase"");
-------------------------------------------------------------------------------------------------

in SQLServer or 

-------------------------------------------------------------------------------------------------
Real DBOpen(""mydatabase"", ""myuser"", ""mypassword"");
Set mySet = DBSeries(""
select to_date(id_date, 'YYYY-MM-DD') as id_date, value
from
(
select '2003-01-01' as id_date, 1 as value from dual union
select '2003-01-02' as id_date, 1 as value from dual union
select '2003-01-03' as id_date, 1 as value from dual union
select '2003-01-04' as id_date, 1 as value from dual union
select '2003-01-05' as id_date, 1 as value from dual union
select '2003-01-06' as id_date, 1 as value from dual union
select '2003-01-07' as id_date, 1 as value from dual union
select '2003-01-08' as id_date, 1 as value from dual union
select '2003-01-09' as id_date, 1 as value from dual union
select '2003-01-10' as id_date, 1 as value from dual
) DATA
order by id_date"", Diario, SetOfText(""MySerie""));
Real DBClose(""mydatabase"");
-------------------------------------------------------------------------------------------------
in ORACLE, and we open the set mySet we can see that the serie inside is a no
named serie."	defect	closed	high		DataBase	head	major	fixed