AnsweredAssumed Answered

ExecuteSQL not working

Question asked by Karnel on Jul 9, 2014
Latest reply on Jul 10, 2014 by monkeybreadsoftware

I have an ExecuteSQL statement which works completely fine in the Data Viewer, and Developer Assistant, yet when I put the same expression into a field calculation I get nothing--not even a ?. It's not even a very complicated statement.

 

Let ( id = T05_CONTRIBUTORS::_fkPeopleID ;

 

ExecuteSQL (

 

"SELECT "Last"

FROM T04_PEOPLE

WHERE PEOPLE_ID = ? ";

 

"";"";id

 

))

 

 

 

Any suggestions?

Outcomes