Hi Bob, > I've got a fairly straightforward table in a MySQL 5.0 database that > looks like this: > > CREATE TABLE invoice > (ID INTEGER NOT NULL PRIMARY KEY, > Customer INTEGER NOT NULL REFERENCES Customer, > DateSubmitted DATE NOT NULL, > Amount DECIMAL(10,2) NOT NULL, > Notes VARCHAR(512) NULL) > > I'm having a number of problems with getting OpenOffice's Base to do the > right thing with this table, but the most frustrating is that when I > create a form based on the table, then go to insert a new row using that > form, I get an error message complaining that the Amount column cannot > be NULL, even though I'm entering a value for that column.
Cannot reproduce with OOo 2.4, Windows XP, MySQL ODBC Driver 3.51, MySQL server 5.0.37 (running on a different machine). I suppose there's something in the way you setup your form - care to create a minimal example form, working on the table above? Also, please mention the exact version of your ODBC driver. A workaround you could try is to uncheck the "Form data input checks for required fields" in the "Edit / Database / Advanced Settings" dialog. > The other problems might be clues to what's causing the first problem, > or they may be unrelated (by improbable coincidence). In the 2.3 OOo on > Ubuntu, when I invoke the form wizard, the list of fields offered for > inclusion on the form omits the Amount column (but the form wizard in > OOo 2.0 on WinNT includes it). Also, both installations show the Amount > column as "Text (fix) [ char ]" when I bring up Edit on the table > definition, Cannot reproduce, with the same setup as above. 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]
