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

    Attempting to use ExecuteSQL

    raykennedy

      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.