Alex Thurgood wrote:
Bob Kline a écrit :
Hi Bob,
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.
So the problem might lie with the ODBC driver version :-)
Sure enough. Hadn't occurred to me, given that the problem was present
in completely different environments, with different versions of the
driver, but apparently they were careful to replicate the bugs across
operating systems and driver versions. I upgraded the ODBC drivers to
the latest version, and all the problems I reported are gone. Now I'll
see if I can goad the Ubuntu maintainer to pick up the upstream bug fix,
so I don't have all my machines working outside the package management
system.
I have not found an ODBC driver version provided by MySQL thus far
that does not have some form of functional limitation when working
with OOo. I can only hope that things will improve now that both
products have developers under the same mothership roof :-))
Let's hope! Thanks for the tips.
--
Bob Kline
http://www.rksystems.com
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
