1 Reply Latest reply on Aug 15, 2013 8:23 PM by philmodjunk

    I have my question about Excludesql command on filemaker

    akepotjewsakul

      Title

      I have my question about Excludesql command on filemaker

      Post

           Hi Team filemaker

           On filemaker can include sql command to layout ? i want to create query for display the reuslt to table

            

           Thank you

        • 1. Re: I have my question about Excludesql command on filemaker
          philmodjunk

               I believe that you are referring to ExecuteSQL() wink

               This is a function, so the results of the SQL query are returned to a field or variable. It cannot be directly used as the record source for a layout.

               It could be used in a very, large, scroll bar equipped field and the result would be very similar to that of a portal.

               And you could use ExecuteSQL to generate a return separated list of Primary Key values and then a relationship to the layout's table occurrence could enable Go To Related Records to pull up a found set of records matching that list.