Can DOA handle multidimensional data?

[sinys]

Can DOA handle multidimensional data? (without master-detail for 2 DataSet)
for example this query (fantasy):

select ..., (select ... from table2 t2 where t2.id = t1.id ) as x, ... from table1 t1

Example processing (my fantasy)

DS1.First;
 while not DS1.Eof do
  begin
     ...
     DS1.FieldByName('x').AsDataSet.First;
     while not DS1.FieldByName('x').AsDataSet.Eof do
       begin
           ...
          DS1.FieldByName('x').AsDataSet.Next;
       end;
    DS1.Next;
  end;

???

 

[Marco Kalter]

It supports cursor fields if that is what you need. For example:

select deptno ,
       cursor(select empno,sal
                from emp
               where emp.deptno = dept.deptno) as employees
 from dept

For the employees cursor field you can use the TOracleQuery.GetCursor function to get the employees for the current department.