Apache OpenOffice Community Forum

I have upgraded from 3.2.1 to 3.3.

I am using a form created in Base to input transaction details into a postgres database using the jdbc interface.
My problem is that when I input a $ amount into the transamount field this field is truncated in that only the dollar amount is inserted.
Your help would be much appreciated. This worked OK in 3.2.1. Test connection & Test class works OK.

Postgresql version 8.3.11 and postgresql-jdbc 8.3.603

Table field types below

transid serial NOT NULL,
transcode character varying(50),
transdate timestamp without time zone,
transdescription character varying(255),
transamount numeric,
CONSTRAINT tranststpk PRIMARY KEY (transid)

What type of form controls you use on transamount field?
Formatted field or Currency field?

I am using a formatted field.
Formatting: Category - Number Format code #.00
thanks

I think you use numeric type wrongly, not defined scale parameter: http://www.postgresql.org/docs/8.3/inte ... IC-DECIMAL

That was the problem - thanks for your help.