I have a table which contains a TEXT field.  Editing this text field causes odd behaviour when edited.  If the text is changed to a non-zero length string, attempting to close the form triggers the unsaved changes dialog.  If the text is set to a zero length string, this is not triggered.  If a non-zero length string is entered and then navigate to another record, the dialog is not issued.

I am using SQLite (3.8.4.3-1) and the ODBC connector (http://www.ch-werner.de/sqliteodbc/ - 0.997).


HOW TO REPRODUCE

Create table
CREATE TABLE tblProject (
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	description TEXT NOT NULL,
	comments TEXT
);

Create two records with nothing in the comments.

Create a form bound to tblProject and a control bound to comments,

Enter a non-zero length string, save the record and close the form.  This will trigger the dialog.

Repeat the previous step, but before closing, navigate to another record.  No dialog is triggered.

Open the record with the non-zero length string.  Change the text to zero length, save the record and close the form.  No dialog is triggered.