Jump to content
Sign in to follow this  
El_Pablo

SQL Create table in a FM file

Recommended Posts

El_Pablo    4

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

Share this post


Link to post
Share on other sites
El_Pablo    4

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.