Re: [Axapta-Knowledge-Village] using 'in' keyword in axapta query

[Varden Morris]

Try this:     select emp where emp.empcode == 'E001' ||                   emp.empcode == 'E002' ||                   emp.empcode == 'E003');     Varden Morris  Senior Developer  WellPoint Systems Inc.  Microsoft Gold Certified PartnerSuite 2000, 500 - 4th Ave SWCalgary, Alberta, Canada T2P 2V6     (403) 444-5848 direct  (403) 444-3900 main  (403) 615-1604 cell  www.wellpoint.caHema Malini <[EMAIL PROTECTED]> wrote:  Hi,i cannot use 'in' keyword in axapta query. forexample, i have sql query as follows:select emp where empcode in('E001','E002','E003');how do i convert it to axapta query format? pls.provide the solution.regs,Hema. S            __________________________________________ Yahoo! DSL – Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com                   Varden Morris Senior Developer WellPoint Systems Inc.   Microsoft Gold Certified Partner  (403) 444-5848 direct (403) 444-3900 main   (403) 615-1604  cellwww.wellpoint.ca [EMAIL PROTECTED]
		 Yahoo! DSL Something to write home about. Just $16.99/mo. or less





Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" 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.