MySQL v5.1

FMP/FMPA v9,10,11

Windows XP, MacOSX 10.5, 10.6

A MySQL field is defined as NOT NULL (e.g. name VARCHAR(255) NOT NULL).

The database and the table where the field is located is linked via External SQL Sources.

When a value is deleted from the field, making it empty, I get the following error on Windows:

ODBC Error: [MySQL][ODBC 5.1 Driver][mysqld-5.0.32-Degian_7ethch1-log]Column was set to data type implicit default; NULL supplied for NOT NULL column '' at row 1

...and on a Mac it is: 

ODBC Error: [Actual][MySQL] Column '' cannot be null

Where is the name of a MySQL field set to NOT NULL.

At that point I'm stuck! I need to enter some value or otherwise it would keep displaying this error message.

According to FileMaker ODBC and JDBC Guide at the beginning of page 35 it says - "Defining a column to be NOT NULL

automatically selects the Not Empty Validation Option for the corresponding field in the FileMaker database file.

The field is flagged as a Required Value in the Fields tab of the Manage Database dialog box in FileMaker Pro."

However, the field is NOT checked as Not Empty NOR flagged as Required.

HELP!!!

So nobody knows?

I am having the same problem in using a SQL data source. Have you found a solution to this problem?

The only reasonable solution I've found is slightly altering MySQL table schema. A field you have problems with should be changed to allow NULL values, and its default value should be NULL.

Another solution, I've tried, is putting a blank space (Auto-Enter Calc.) in a field.

Edited June 16, 201015 yr by Guest