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.
This problem is occurring regardless of OOo version or client platform
(e.g., OOo 2.3 on Ubuntu Gutsy, or OOo 2.0 on Windows NT). I'm telling
OOo that the database is MySQL and I'm connecting over ODBC.
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, and trying to correct that doesn't stick (next time I open
the Editing windows on the table definition, my Decimal 10, 2 is gone,
and it's back to "Text (fix) [ char ]").
Is this a known bug (or bugs)?
--
Bob Kline
http://www.rksystems.com
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
