To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=56921
Issue #:|56921
Summary:|DB write errors with fixed-point values ...
Component:|Database access
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|hpheidinger
------- Additional comments from [EMAIL PROTECTED] Sat Oct 29 05:53:39 -0700
2005 -------
Platforms: Linux & WinXP
DBdriver: JDBC3
DBMS: PostgreSQL V8.x (8.0.3)
OO: OOo V2.0 DE
Table definition by DDL:
CREATE TABLE junk
(
id serial NOT NULL,
preis numeric(5,2),
bezahlt bool,
CONSTRAINT junk_pkey PRIMARY KEY (id)
)
WITH OIDS;
------------------------------------
Actually I tried both StarOffice 8 (Linux) & OOo V2.0 ...
Trying to write fixed-point values (e.g. 49,00 [German/European repr.]) to the
DB from SO8/OOo2.0 results in errors.
The resulting message is:
ERROR: column <preis> has type numeric but expression has type character varying
This happens with OOo2.0 and PostgreSQL8 on Windows (check on a notebook
installation) as well als SO8 & OOo2.0 against a PostgreSQL-DBMS on
Linux-HA-Cluster.
- It works, if the column 'preis' is defined as a floating-point value (REAL,
DOUBLE).
- It works with fixed-point data definition ( NUMERIC(5,2), MONEY, ... ) on an
ODBC connection - in which case the SERIAL groks ...
Ideas welcome ...
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
