I need to make relation between two tables's fields
with in the code. I want to get something like that:
"select * table1 join table2 where table1.fieldA ==
table2.fieldB"
i try this:
Query q;
<..>
;
q = new Query();
qbds1 = q.addDataSource(tableNum(Table1));
qbds2 = qbds1.addDataSource(tableNum(Table2))
how can i relate Table1.FieldA with table2.fieldB now?
qbds2.addLink(FieldNum(table1, fieldA),
FieldNum(table2, fieldB));
gives me wrong where clause.
maybe it should be used .addrelation() method if yes
then how?
thanks
=====
Paulius Cerniauskas
Phone: +37062049339
ICQ: 280959446
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
| 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.
