AnsweredAssumed Answered

ExecuteSQL problem

Question asked by KevinMortimer on Jul 24, 2012
Latest reply on Jul 24, 2012 by fmpros



I am getting to grips with new executeSQL function and finding it very useful but i am struggling with a very basic search. I have checked reserved words and there seems to be no conflict. I have this calculation which works fine and returns the result of John


ExecuteSQL ( "SELECT nameFirst FROM contacts WHERE id = 10002" ; NULL ; NULL )


but when i reverse the search it below calculation returns a ? I am expecting it to return id 10002, why is this failing?...any ideas?


ExecuteSQL ( "SELECT id FROM contacts WHERE nameFirst = John" ; NULL ; NULL )