Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    48

    Unanswered: Macro substitution , evaluate variable

    Hi,

    I am trying to get value from field in table but the fieldname is variable

    e.g my Fields in table are = Qty1 Numeric, Qty2 Numeric, Qty3 Numeric
    my field name is in variable v_field = 'Qty1'
    How can i evaluate v_field to get value of the field Qty1

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Google "dynamic sql"
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •