SV: [development-axapta] how to set range on dimension?

[Jacob Hjelmer Nielsen]

Adding array elements like the Dimension EDT requires a special effort since addressing the array elements requires some extra functionality, consider the following example;

Query query;

QueryBuildDataSource qB;

QueryBuildRange qR;

Counter idx;

Dimension dimension;

;

query = new Query();

qB = query.addDataSource(tableNum(CustTable));

for (idx = 1; idx <= dimOf(dimension); idx++)

{

    qB.addRange(fieldId2Ext(fieldnum(CustTable,dimension), idx));

            qB.value("Somevalue");

}

We use the dimOf() method to get the number of array elements in the EDT, and afterwards we address the individual array elements by the use of the method fieldId2Ext. 

:-J

 

Systemdeveloper 

Jacob Hjelmer 

 

Thy Data Center Development A/S

Søvej 13b

DK-3460 Birkerød

Denmark

Phone : +45 96 170 470 

Fax   : +45 45 824 544 

 URL   : http://development.thydatacenter.dk/ <blocked::http://development.thydatacenter.dk/>  

E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  


 
________________________________

Fra: Paulius Cerniauskas [mailto:[EMAIL PROTECTED] 
Sendt: 30. november 2004 16:17
Til: [EMAIL PROTECTED]
Emne: [development-axapta] how to set range on dimension?


let say that i need to filter projects by dimension's 
field's value,  when i try this:

<....>
     qbr = qbds.addRange(fieldnum(projtable,
dimension));
     qbr.value("someValue");

compiler does not produce an error, but the result is
not what i need,

when i try something like that:
     qbr = qbds.addRange(fieldnum(projtable,
dimension[3]));
     qbr.value("someValue");

compiler gives an error.

how to set range on ProjTable.dimension[3]?


=====
Paulius Cerniauskas
Phone: +37065923155
ICQ: 280959446


            
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 


Yahoo! Groups Sponsor      
 <http://us.ard.yahoo.com/SIG=129tm3ela/M=296572.5585671.6651487.3001176/D=groups/S=1705006764:HM/EXP=1101925015/A=2343726/R=0/SIG=12i34buc3/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1101838615171113>  <http://us.ard.yahoo.com/SIG=129tm3ela/M=296572.5585671.6651487.3001176/D=groups/S=1705006764:HM/EXP=1101925015/A=2343726/R=1/SIG=12i34buc3/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1101838615171113> 

Get unlimited calls to

U.S./Canada

 <http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1101838615171113> 
 <http://us.adserver.yahoo.com/l?M=296572.5585671.6651487.3001176/D=groups/S=:HM/A=2343726/rand=538145895>       

________________________________

Yahoo! Groups Links


*      To visit your group on the web, go to:
      http://groups.yahoo.com/group/development-axapta/
        
*      To unsubscribe from this group, send an email to:
      [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
        
*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . 




[Non-text portions of this message have been removed]










Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.