Bob Kline wrote:
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)?
Hi Bob,
Just a thought. Have you tried switching over to a JDBC driver instead
of the ODBC driver to see if that clears up your problem?
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
