5 Replies Latest reply on Feb 7, 2017 5:01 AM by Lizhe

    Sql to get field names from a table

    Lizhe

      I'm trying to get all field names from a table by following the examples given from the following link:

      http://www.databuzz.com.au/using-executesql-to-query-the-virtual-schemasystem-tables/

       

      I tested the examples one by one, it works until the following step:

      ExecuteSQL ( “SELECT FieldName FROM FileMaker_Fields WHERE TableName=’Tasks'” ; “” ; “”  )

       

      The data view shows that Sql treats 'Task" as column name, not table name. Therefore, no data was returned from my solution.

      The comments for the above link is closed and I need help to fix the problem of the Sql statement.

       

      Thanks.

       

       

      L