Hi Anton,
if u want to use direct select statement,
use this code.
While select salesid, payment, projid, salesresponsible, createddate
from salestable
where salestable.Dimension[5] == _Branch
{
}
----- Original Message -----
From: "anton_tjiptadi" <[EMAIL PROTECTED]>
To: <Axapta-Knowledge-Village@yahoogroups.com>
Sent: Friday, December 24, 2004 11:08 AM
Subject: Re: SV: [Axapta-Knowledge-Village] EDT -> Dimensions
>
>
> hi,
> what if I want to do it in "while select" statement ?
> for ex :
> While select salesid, payment, projid, salesresponsible, createddate
> from salestable
> where fieldid2ext(fieldnum(salestable, dimension),5) == _Branch
> {
> }
> (above statement cause error ->Container and unbounded string (text)
> fields are not allowed in a WHERE expression.)
>
> thanks,
> Merry Christmas or Happy Holiday to all of U ..... :))
>
>
>
> --- In Axapta-Knowledge-Village@yahoogroups.com, "Lars Holm"
> <[EMAIL PROTECTED]> wrote:
> > Perhaps replace 1 with a comile time check, like this:
> >
> > range = dsInventTable.addRange(fieldid2ext(fieldnum(InventTable,
> Dimension), SysDimension::Department+1));
> >
> > Br,
> > Lars
> >
> > ________________________________
> >
> > Fra: Varden Morris [mailto:[EMAIL PROTECTED]
> > Sendt: ma 20-12-2004 13:23
> > Til: Axapta-Knowledge-Village@yahoogroups.com
> > Emne: Re: [Axapta-Knowledge-Village] EDT -> Dimensions
> >
> >
> > You can try this:
> >
> > range1 = dsInventTable.addRange(fieldid2ext(fieldnum
> (InventTable,Dimension),1))
> > OR
> > range2 = dsInventTable.addRange(fieldid2ext(fieldnum
> (InventTable,Dimension),2))
> > OR
> > range3 = dsInventTable.addRange(fieldid2ext(fieldnum
> (InventTable,Dimension),3))
> >
> >
> >
> > Varden Morris
> >
> >
> >
> > J. Wray & Nephew Ltd. - Group I.S.
> >
> > 234 Spanish Town Road
> >
> > Kingston 11, Jamaica, W.I.
> >
> >
> >
> > Phone: (876) - 923 - 6141 Ext. 2400, 2412
> > Fax: (876) - 923 - 5372
> >
> > Cell: (876) - 3833566
> > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >
> > [EMAIL PROTECTED]
> <http://us.f414.mail.yahoo.com/ym/[EMAIL PROTECTED]>
> > anton_tjiptadi <[EMAIL PROTECTED]> wrote:
> >
> >
> > Hi, how to manipulate field Dimension ('cause it's an array
> var) ?
> >
> >
> > for example :
> > range1 = dsInventTable.addRange(fieldnum(InventTable,
> dimension));
> >
> > -> I want to filter my report by dimesion number 4, how
> should I
> > write it in code, I tried by specifying the array ->
> dimension[4] but
> > its cause error
> >
> > thanks,
> >
> >
> >
> >
> >
> > Sharing the knowledge on Axapta.
> >
> >
> >
> >
> > ________________________________
> >
> > Do you Yahoo!?
> > The all-new My Yahoo! <http://my.yahoo.com> - Get yours free!
> >
> > Sharing the knowledge on Axapta.
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> > click here
> <http://us.ard.yahoo.com/SIG=129jluhdf/M=294855.5468653.6549235.30011
> 76/D=groups/S=1705001380:HM/EXP=1103631801/A=2455396/R=0/SIG=119u9qmi
> 7/*http://smallbusiness.yahoo.com/domains/>
> >
> >
> > ________________________________
> >
> > 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]
> <mailto:[EMAIL PROTECTED]
> subject=Unsubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
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/
