close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 17 years ago

Last modified 15 years ago

#550 assigned defect

DBTableColumn function does not work — at Initial Version

Reported by: Alfredo Torre Owned by: danirus
Priority: highest Milestone:
Component: Database Version: 1.1.6
Severity: blocker Keywords:
Cc: imendez, Javier Gallardo

Description

Please, run this TOL code:


Real DBOpen(_DB_, _USER_, _PASS_);
Text Qry =
"
select 'A' as c1, 'X' as c2, 1 as c3 UNION
select 'A', 'Y', 1 UNION
select 'B', 'X', 2 UNION
select 'B', 'Z', 3
order by c1, c2
";
Set XXX01 = DBTable(Qry);
Set XXX02 = DBTableColumn(Qry, 1, 1);

Real DBClose(_DB_)

I think XXX02 Set should be:

Set [[

"", "A", "B" ?, TABLE HEADER
"X", 1 , 2 ?,
"Y", 1 , ? ?,
"Z", ? , 3 ?
]];

I don't know if the first element (TABLE HEADER) should be in the returned Set.

Change History (0)

Note: See TracTickets for help on using tickets.