Issue 107207

Summary: Optional field in mdb left blank fails (cannot be saved)
Product: Base Reporter: sanyock <sanyock>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO310m11   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sample files none

Description sanyock 2009-11-25 16:40:57 UTC 
I connected OOBase to an MS Access MDB file created from ODBC manager. 
Everything seems working fine except optional fields. I was able to design a 
database structure. But when editing a table data it does not let me leave an 
optional long integer blank. 

Would anyone please suggest how can this be fixed? 

Note: optional text fields work as expected
Comment 1 sanyock 2009-11-25 18:35:29 UTC 
It actually seems to be another problem: OOBase does not save 
"optional" (nullable) attribute for a field.
I reopened the database in the designer and fields are "required" again though 
I marked them as "not required".
Trying to save them as "not required" does not help.
The files have been attached.
Comment 2 sanyock 2009-11-25 18:36:24 UTC 
Created attachment 66346 [details]
sample files