JohnM_2

Execute SQL Reference for Creating Filemaker tables programmatically

Discussion created by JohnM_2 on Aug 3, 2016
Latest reply on Aug 3, 2016 by user19752

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

Outcomes