Issue 110582 - impossible to create a new item in a base with
Summary: impossible to create a new item in a base with
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2010-04-03 10:39 UTC by gseguinot
Modified: 2010-09-21 13:45 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Error Message (14.31 KB, image/png)
2010-04-03 10:40 UTC, gseguinot
no flags Details
Office Document Use (771.40 KB, application/vnd.sun.xml.base)
2010-04-03 10:42 UTC, gseguinot
no flags Details
Error message Follow (20.18 KB, image/png)
2010-04-03 10:48 UTC, gseguinot
no flags Details
Performing the record (139.48 KB, image/png)
2010-04-03 10:56 UTC, gseguinot
no flags Details
Table with the created "in error" items (34.39 KB, image/png)
2010-04-03 11:00 UTC, gseguinot
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gseguinot 2010-04-03 10:39:18 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.
Comment 1 gseguinot 2010-04-03 10:40:36 UTC
Created attachment 68715 [details]
Error Message
Comment 2 gseguinot 2010-04-03 10:42:29 UTC
Created attachment 68716 [details]
Office Document Use
Comment 3 gseguinot 2010-04-03 10:48:46 UTC
Created attachment 68717 [details]
Error message Follow
Comment 4 gseguinot 2010-04-03 10:56:35 UTC
Created attachment 68718 [details]
Performing the record
Comment 5 gseguinot 2010-04-03 11:00:18 UTC
Created attachment 68719 [details]
Table with the created "in error" items
Comment 6 gseguinot 2010-04-03 11:30:31 UTC
Was working fine in 2.4 3.0.1 3.1.1....
Comment 7 gseguinot 2010-05-01 14:12:51 UTC
As ubuntu 10.04 LTS Use this version as base, the problem is now FULL ....

We have to uninstall to  downgrade as 3.01
Comment 8 gseguinot 2010-05-01 14:26:38 UTC
No activity at all on this issue wich become general as Ubuntu 10.04 is ready.
Comment 9 r4zoli 2010-05-01 17:30:52 UTC
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?
Comment 10 drewjensen.inbox 2010-05-02 21:12:26 UTC
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.



Comment 11 gseguinot 2010-05-03 07:37:35 UTC
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. 
Comment 12 drewjensen.inbox 2010-05-04 06:44:17 UTC
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?
Comment 13 gseguinot 2010-05-08 15:06:54 UTC
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.
Comment 14 r4zoli 2010-09-21 13:40:45 UTC
Set Invalid.
Comment 15 r4zoli 2010-09-21 13:45:23 UTC
I wrongly set it as invalid, but no answers in long time.
I keep invalid as no others reopen it, and close.
Comment 16 r4zoli 2010-09-21 13:45:55 UTC
Invalid -> Closing.