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  qbd1,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 | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.