Apache OpenOffice (AOO) Bugzilla – Issue 110582
impossible to create a new item in a base with
Last modified: 2010-09-21 13:45:55 UTC
Language French Using Postgresql 8.4 as DB manager. Using jdbc connector postgresql-8.4-701.jdbc4.jar unique Id is an auto-incremented number (integer) Open Formula fill all the fields push create. A mesage appears : "status SQL 24000 le resultset n'est pas positionné correctement, vous devez peute tere appeler next()" the uid does not appear in the formula. The record is created anyway in the table.
Created attachment 68715 [details] Error Message
Created attachment 68716 [details] Office Document Use
Created attachment 68717 [details] Error message Follow
Created attachment 68718 [details] Performing the record
Created attachment 68719 [details] Table with the created "in error" items
Was working fine in 2.4 3.0.1 3.1.1....
As ubuntu 10.04 LTS Use this version as base, the problem is now FULL .... We have to uninstall to downgrade as 3.01
No activity at all on this issue wich become general as Ubuntu 10.04 is ready.
You use OOo downloaded from OOo site, or use ubuntu own version? What happens if you use sdbc driver? (openoffice.org-sdbc-postgresql package, if you use ubuntu version) x86 or 64 bit version?
Ran the following: Ubuntu studio 10.04 (pretty much new) Installed Postgresl 8.4 and 8.4-701 JDBC connector. Created a new database/schema/user then created a table in the pgAdmin as: -- Table: msis.pgadm_table1 -- DROP TABLE msis.pgadm_table1; CREATE TABLE msis.pgadm_table1 ( id serial NOT NULL, val character varying, num numeric, CONSTRAINT pgadm_table1_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE msis.pgadm_table1 OWNER TO "OOo_Admin"; Then used OO.o 3.2 from the Ubuntu build and created a connection then created the a table definition using Base GUI: this is geneerated: -- Table: msis."Table1" -- DROP TABLE msis."Table1"; CREATE TABLE msis."Table1" ( id integer NOT NULL DEFAULT nextval('msis."Table1_id_seq"'::regclass), val character varying, num numeric, CONSTRAINT "Table1_pkey" PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE msis."Table1" OWNER TO "OOo_Admin"; OK then trying to add data using OO.o 3.2 from Ubuntu OO.o 3.2 m_12 Vanilla OOO320m_16 and DEV300m_17 - no problem adding data to either table.
In fact yes I can add manually any record. I just forget to say I am using a pre-defined "formulaire" in OOo Base this one was written in 2.4 and was working fine in 3.0, in 3.1, and does not work on 3.2 without modifications, and in any OS as I use it in Windows XP and Vista, Ubuntu Lucid x86 and Ubuntu Lucid AMD_64.
ok - I think I'm with you now. I can open the forms against non-existent tables, and there I guess is the problems, the filter statements on the dataforms. this is a problem with 3.2 in general, not just when connected to postgres. Before I mark as a duplicate though - you say that you modify the forms to work in 3.2, is that modification for the filter statements?
No i have not modified the formula, I use it as it was created in 2.4 version. And I skip 3.1.0 version because of a bug in selection from a table. In fact my appliacation stop to run ahater 3.0.1 but not for the same reason.
Set Invalid.
I wrongly set it as invalid, but no answers in long time. I keep invalid as no others reopen it, and close.
Invalid -> Closing.