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 ;
WHERE PEOPLE_ID = ? ";