1 Reply Latest reply on Nov 11, 2006 8:56 AM by PaulKD

    Dynamic Variable Naming Help

    asdren_one Level 1
      I have a SQL INSERT statement that has the following:

      #QueryData.currentyear#

      but currentyear is actually a variable, a LIST specifically:
      JAN_2003,FEB_2003,MAR_2003,APR_2003,MAY_2003,JUN_2003

      so I need the statement in the SQL query
      to evaluate #QueryData.JAN_2003#
      and on next loop to #QueryData.FEB_2003# and so on

      how can I specify that "currentyear" is a variable?

      thanks in advance