El_Pablo Posted November 27, 2008 Share Posted November 27, 2008 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 More sharing options...
El_Pablo Posted November 27, 2008 Author Share Posted November 27, 2008 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 More sharing options...
Peter Wagemans Posted September 8, 2014 Share Posted September 8, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3658 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 accountSign in
Already have an account? Sign in here.
Sign In Now