AnsweredAssumed Answered

ExecuteSQL problem

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

Hi

 

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 fails...so 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 )

Outcomes