NT 4 SP 4, WO 4.0, ODBC Adaptor (updated with latest M$ patch), Access 97 DB. I fetch an existing object that has several string fields, one of them (Notes) represents a Memo or Longtext field in the Access DB, and so this is not marked as Locking in my model (if it is marked as locked it causes other problems). Now, updating any string other than Notes, all works fine. When I update Notes with any contents except empty, it all works fine. When I try to update Notes with an empty string, it never saves these changes to the DB. The EO object sees the change, but never, ever stores it, so whenever the program is restarted for whatever reason, any blanked Notes fields are returned to whatever they contained previous to blanking. The Model has the Notes field marked as 'Accepts Null'. This should be a simple fix but I can't find what is wrong, and it is getting increasingly annoying as can never blank out these fields and have lots of them. Have to insert a space at the moment. Anyone know about this as it would be nice to put empty string in there. EOF doesn't report any problems, no exceptions are raised, no other problems seem to arise, it simply ignores writing to the DB when the field has been blanked, and for that field only. Access has the field set to allow zero length, and is not required or indexed. Any indicators much appreciated! --- Mike Llewellyn Nexan Telemed Ltd
