Hi..I'm a newbie and need some help from the expert.Below is a simplify exa=
mple for my
problem.

I'm using three table:
Table1 - id,name,age
Table2 - name , address
Table3 - age , status

Inside Fetch Method:
Query q =new query();
QueryRun qr;
QueryBuildDatasSource &nbspqbd1,qbd2,qbd3;
QueryBuildLink qbl1,qbl2;
Table1 _table1;
Table2 _table2;
Table3 _table3;

qbd1 = q.addDataSource(TableNum(Table1));
qbd2 = qbd1.addDataSource(TableNum(Table2));
qbd2.joinmode(JoinMode::InnerJoin);
qbl1 = qbd2.addlink(FieldNum(Table1,Name),FieldNum(Table2,Name));
qbd3 = qbd1.addDataSource(TableNum(Table3));
qbd3.joinmode(JoinMode::InnerJoin);
qbl2 = qbd3.addlink(FieldNum(Table1,Age),FieldNum(Table3,Age));

qr = New QueryRun(q);

while(qr.next())
{ THIS IS THE PART THAT I'M NOT SURE.I WANT TO USE ELEMENT.GET AND ELEMENT.=
SEND.
I HOPE YOU GUYS CAN FILL THIS PART
}

I want the report to look something like this:
ID   NAME   ADDRESS   STATUS

Thanx in advanced,Bye.



Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to