MySQL NOT NULL Fields & FileMaker ESS Issues

[wimpog]

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!!!

[wimpog]

So nobody knows?

[Terry Kakavros]

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

[wimpog]

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, 2010 by Guest