2 Replies Latest reply on Aug 3, 2016 8:00 AM by user19752

    Execute SQL Reference for Creating Filemaker tables programmatically


      I just found out that you can use Execute SQL to Create Filemaker tables programmatically.


      Using FileMaker ODBC - as the DSN - I executed:

      create table newtable (id varchar,   text1 VARCHAR, number decimal)


      hat are the various possible types that I can use when creating a Filemaker TABLE?

      and can I pass more parameters for each field?

      Is there a good reference manual for this?  for Filemaker 14?


      Can I get some help then for the syntax to insert data into the various field types?


      I can see that if I wanted to convert an SQL DB to Filemaker - I could generate a script which I could modify and run it in Execute SQL.


      Thanks in Advance