Hi Drew, (having the impression you're trying to catch me, step-wise :)
> Create a form for the table (using individual controls) > Set the "Empty String = NULL" property for the remarks field to NO. > Set the database wide property "Form data input checks for required > fields" to false. (take the tick mark away) > > Go to the Inert row. > Add data for all fields except remarks - click on save record. > Error - "The field 'customer.remarks' can not contain a NULL value. > > The application is still behaving 'as designed', right? Uhm - no. The control should write an empty string (since "Empty string is NULL" is No), the forms runtime should not tamper with it, and the DB back-end should accept the empty string. Could reproduce this behavior, but it's unexpected. Will have a look. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
