Jump to content

SQL Create table in a FM file


This topic is 3489 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 5 years later...

This topic is 3489 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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