3 Replies Latest reply on Sep 19, 2015 5:54 PM by raykennedy

    Attempting to use ExecuteSQL


      I am attempting to experiment with ExecuteSQL. I am familiar with MySQL so the syntax is very comfortable. In this example I am using two tables.


      Table 1: CONTACT (with records entered)

      Table 2: TEST_SQL (there is no relationship created in relationship graph)


      On the TEST_SQL layout I just simply put  a field called results just to experiment with some basic queries. This is a calculation field set to "text" with this basic ExecuteSQL statement in the calculations options.


      ExecuteSQL("SELECT CONTACT::conLastName FROM CONTACT"; "";"")


      The result I get is a ?.


      Is there something I am missing, is there a reason why this won't execute? My understand there does not have to be a relationship setup in the graph for SQL calls or am I mistaken?


      See an attached photo to help demonstrate what I am doing if needed. If it is important, I am OS X Yosemite (10.10). Currently have Filemaker pro Advanced 12 but am using the trial version of Filemaker Pro 14.