it seems i found out the problem: fields in addlink()
method were listed in wrong order.
......
--- Paulius Cerniauskas <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
>
=====
Paulius Cerniauskas
Phone: +37062049339
ICQ: 280959446
__________________________________
Do you Yahoo!?
Jazz up your holiday email with celebrity designs. Learn more.
http://celebrity.mail.yahoo.com
| 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.
