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/