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 )