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.