user17750

ExecuteSQL does not get information from a calculation field?

Discussion created by user17750 on May 29, 2013
Latest reply on May 29, 2013 by Mike_Mitchell

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

Outcomes