I'm having trouble trying to create a table in a FM file using SQL.

I'm testing the communication between .Net and Filemaker.

The following command returns an error

CREATE TABLE customer (First_Name text)

Error message

[17:59] Erreur  ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Bad Column Type: First_Name

ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Query Failed

Does someone have an idea on how to create a table using SQL command?

Thanx

Just found the answer.

CREATE TABLE customer (first_name varchar)

is the right type.

BTW here are the data type accepted in FM.

varchar (for text)

float (for number)

date

time

timestamp

blob (for container)

Haven't found the equivalent for calculation and summary. Surely someone could answer this problem.

Yes, you can't ( no pun intended ).

A calculation has a datatype as described above. But there is currently no way to create a calculation field through SQL.