Re: [development-axapta] Join datasource with 2 fields

2005-08-23 Thread Paulius Cerniauskas




Join datasources with "OR" operator Directly is
impossible, but see ProjTable'e method
lookupProj_Web()for example. I am not sure it what you
need, but there query conditions are  formed in a bit
different way.

--- kamchung322 <[EMAIL PROTECTED]> wrote:

> Hi All, 
> 
> I want to join 2 datasources with 2 fields. 
> Following is the code : 
> 
> QueryBuildDataSource  qb;
> qb = this.query().dataSourceNo(2;
> qb.addLink(FieldNum(Table1, Field1),
> FieldNum(Table2, Field1));
> qb.addLink(FieldNum(Table1, Field2),
> FieldNUm(Table2, Field2));
> 
> the above code will join the datasources with Field1
> AND Field2 but I
> want to join it with Field1 OR Field2.  Is it
> possible to do it ? 
> 
> Regards.
> 
> Kenneth. 
> 
> 
> 
> 
> 
> 
> 


Paulius Cerniauskas
Phone: +37062049339
ICQ: 280959446


    

Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 









  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  









[development-axapta] Join datasource with 2 fields

2005-08-22 Thread kamchung322




Hi All, 

I want to join 2 datasources with 2 fields.  Following is the code : 

QueryBuildDataSource  qb;
qb = this.query().dataSourceNo(2;
qb.addLink(FieldNum(Table1, Field1), FieldNum(Table2, Field1));
qb.addLink(FieldNum(Table1, Field2), FieldNUm(Table2, Field2));

the above code will join the datasources with Field1 AND Field2 but I
want to join it with Field1 OR Field2.  Is it possible to do it ? 

Regards.

Kenneth. 












  
  
SPONSORED LINKS
  
  
  

Computer part
  
  
Programming languages
  
  
Microsoft axapta
  
  


Support exchange
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.