Try to use queries, and set the range for the emplCode and give the values as E001, E002, E003.
The code would be something like this
QueryBuildDatasource qbs;
QuerybuildRange qbr;
query q = new query();
qbs = q.addDatasource(tablenum(emplTable));
qbs.addrange(fieldNum(EmplTable,EmplCode));
qbs.value('E001, E002, E003');
"Sathiyanathan.P - Leader (Enterprise Solutions Practice) - SIS" <[EMAIL PROTECTED]> wrote:
Hi Hema
Varden's suggestion is correct,
Where u r using this Select,
In executequery method
use only the Select statement .....
example
select emp where emp.empcode == 'E001' ||
emp.empcode == 'E002' ||
emp.empcode == 'E003'
In normal Methods for fetching record
use While Select;
example
while select emp where emp.empcode == 'E001' ||
emp.empcode == 'E002' ||
emp.empcode == 'E003'
Regards
P.Sathiya
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of Hema
Malini
Sent: Tuesday, January 10, 2006 12:37 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] using 'in' keyword in axapta
query
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
"Sathiyanathan.P - Leader (Enterprise Solutions Practice) - SIS" <[EMAIL PROTECTED]>
___________________________________________________________________________
Visit us at www.sundaraminfotech.in
___________________________________________________________________________
This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure.
___________________________________________________________________________
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
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.
