4 Replies Latest reply: Feb 6, 2014 12:38 PM by Paul McCormick RSS

    Loop through table values to input into a procedure

    Paul McCormick

      Hi,

       

      I am trying to do a bit of repetitive work through a procedure.  The procedure itself works fine, but when trying to feed in values I am getting null values.  Below is the code, pretty sure its a simple mistake, so any help would be great.

       

       

      LIST:
      LOAD * INLINE [
          Table Name, Search Value, First Wild, Second Wild, Tag
          MONTHLY_LEU, PSO, *, *, PSO
          MONTHLY_LEU, Imperfections Charge¬, *, *, IMPERFECTIONS
          MONTHLY_LEU, Total Units, , *, POPULAR
          MONTHLY_LEU, Moyle Interconnector Charge, *, *, MOYLE
          MONTHLY_LEU, Availability Charge, *, *, AVAIL
          MONTHLY_LEU, CCL¬, *, *, CCL
          MONTHLY_LEU, SCC¬, *, *, SCC
          MONTHLY_LEU, Monthly Charge¬, *, *, MARKET_OP_CHARGE
          MONTHLY_LEU, Market Operator Charge¬, *, *, MARKET_OP_CHARGE
      ];
      
      
      
      
      
      Let RCount=NoOfRows('LIST');  
      For i=0 to $(RCount) -1  
      
      call RateAndConsumption( peek([Table Name],$(i)),peek([First Wild],$(i)),peek([Second Wild],$(i)),peek(Tag,$(i)))
      
      Next i;
      

       

       

       

       

       

       

      Thanks

      Paul