Lizhe

Sql to get field names from a table

Discussion created by Lizhe on Feb 6, 2017
Latest reply on Feb 7, 2017 by 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

Attachments

Outcomes