Hi,
Thank u for ur suggestion. when i use ur code, i will
get only one record. but, i want all the records which
are satified. for eg. E001 and E003 are satisfied,
those will be populated. i use querybuildrange and got
the result.
regs,
Hema. S
--- Varden Morris <[EMAIL PROTECTED]> wrote:
> Try this:
>
> select emp where emp.empcode == 'E001' ||
> emp.empcode == 'E002' ||
> emp.empcode == 'E003');
>
>
> Varden Morris
> Senior Developer
> WellPoint Systems Inc.
> Microsoft Gold Certified Partner
> Suite 2000, 500 - 4th Ave SW
> Calgary, Alberta, Canada
> T2P 2V6
>
> (403) 444-5848 direct
> (403) 444-3900 main
> (403) 615-1604 cell
> www.wellpoint.ca
>
> Hema Malini <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i cannot use 'in' keyword in axapta query. for
> example, 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
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
>
>
> SPONSORED LINKS
> Business finance course Business to
> business finance Small business finance
> Business finance consultant Business finance
> magazine Business finance schools
>
> ---------------------------------
> 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.
>
>
> ---------------------------------
>
>
>
>
>
>
> Varden Morris
> Senior Developer
> WellPoint Systems Inc.
>
>
>
> Microsoft Gold Certified Partner
>
> (403) 444-5848 direct
> (403) 444-3900 main
> (403) 615-1604 cell
> www.wellpoint.ca
> [EMAIL PROTECTED]
>
>
>
>
>
>
>
> ---------------------------------
> Yahoo! DSL Something to write home about. Just
> $16.99/mo. or less
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
