OpenOffice and MySQL NUMERIC/DECIMAL oddity
- From: Steve Ackman <steve@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 30 Apr 2007 08:58:38 -0400
I've googled this problem, and don't find anything
relevant. Maybe someone here has run across this?
The environment:
Debian 4.0 (2.6.18-4-486)
OpenOffice 2.0.4
ODBC (libmyodb-3.51.11-6.1)
MySQL 5.0.32
(all installed via synaptic)
The bug:
When using OpenBase to view an already existing
database, all data appears as expected.
When modifying data, everything works as expected
*except* with fields of decimal type -- specifically decimal(4,2)
and decimal(3,2) here -- when the cursor is moved to a
different row, or when you exit the program, the data
disappears from any decimal cell where the data has been
modified.
IOW, once you've modified data in any decimal cell,
the data is lost, no matter what you do.
I can insert decimal data into those fields using the
MySQL client, so it's got to be a problem with OO or
the ODBC driver rather than with MySQL.
Before I take the next step of downloading OO-2.2
and/or MyODBC 3.51.12 or 3.51.14 from non-deb sources,
and just randomly swapping out parts, or going to
a store-as-integers(cents)-and-divide-by-100 hack,
I was wondering if anyone had run across this before.
.
- Prev by Date: Re: Distro Poll, what do you use?
- Next by Date: Re: Distro Poll, what do you use?
- Previous by thread: Distro Poll, what do you use?
- Index(es):
Relevant Pages
|
