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/> .
------------------------ 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/
