3 Replies Latest reply on May 29, 2013 5:34 AM by Mike_Mitchell

    ExecuteSQL does not get information from a calculation field?

    user17750

      ExecuteSQL (

       

      "SELECT Full_Name_c From Test" ; "" ; ""

      )

       

       

      I have a field called Full_Name_c which is a calulation field containing First_Name &" "&Last_Name

       

      But the SELECT statment pulls no data.

       

      If I replace the Full_Name_c in the above SELECT statement with First_Name it works.

       

      Does the SELECT statement not work with calculation fields???

       

      Thanks for your thoughts and help on this one!!

       

      Nick