Hi,
Thank u for ur solution. i have already tried using
range.
regs,
Hema. S
--- Amit Jain <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
>
>
=== message truncated ===
__________________________________________
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/
