Issue 109898

Summary:

oForm.insertRow() doesn't work correct

Product:

Base

Reporter:

robbygro <robert>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

UNCONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

drewjensen.inbox, issues, weigel

Version:

OOo 3.2

Target Milestone:

---

Hardware:

Unknown

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

111205

Issue Blocks:

Attachments:

Description	Flags
insertRow() in a subform	none
try to input values in the query whithout a value for "gruppeID"	none

Description robbygro 2010-03-07 14:26:45 UTC

When inserting data in a table with "insertRow()" the data were inserted. I can
find them in the table but the macro pops up with "no data is available".
The same macro works correct with OOo 3.1.1

Comment 1 robbygro 2010-03-07 14:58:54 UTC

Created attachment 68194 [details]
insertRow() in a subform

Comment 2 robbygro 2010-03-07 15:04:56 UTC

In a mainform insertRow() works correct. In a subform it does not work, when the
subform isn't connected with the mainform. The example shows names. In the
subforms the names should get a group. In OOo 3.1.1 it works with the macro:
First insertRow(), then reading the insertID and put it in the maintable. OOo
3.2 inserts the values (could be more than one times) in the table "gruppe" and
stops with "no data is available"

Comment 3 drewjensen.inbox 2010-03-07 17:07:18 UTC

Well, I think this is actually another example of the error reported in
http://www.openoffice.org/issues/show_bug.cgi?id=108390

It's not identical of course but I would guess it is the same root cause.

That is already fixed and waiting for the first 3.2.1 developers build for
testing. Will check this file against that dev build ASAP after it is released.

Comment 4 robbygro 2010-03-07 19:37:24 UTC

It's the same problem when you construct a query like 
"SELECT "Name" FROM "Table" WHERE "ID" IN (SELECT "nameID" FROM "Anothertable")"

You will get a query with the possibility to put in new values. But it returns
"no data is available" and with every "OK" on the popup it puts in more the data
which is "not available" into "Table".

Comment 5 robbygro 2010-04-28 11:26:29 UTC

I have tested OOO320m16 with 
"SELECT "Name" FROM "Table" WHERE "ID" IN (SELECT "nameID" FROM "Anothertable")"

It does not work. Only filtered data in one table work now.

Comment 6 robbygro 2010-04-30 19:03:20 UTC

After the test in OOO320m16 I have added a new version of my first attachment.
There is a form and a query. The query will work when the filtered value is the
value you have putted in. The query will return "not available" when the
filtered value isn't put in. At the same time the data has been saved in the
background.
Seems that the gui will refresh data and calls HSQLDB for all the rows which are
in the query - but the last input could not be a result and is not available
from the database. There wasn't any refresh in earlier versions of OOo-Base at
this time.
The form shows the problem with insertRow() - and a new problem for a new issue:
Not text in the textfields.

Comment 7 robbygro 2010-04-30 19:05:55 UTC

Created attachment 69205 [details]
try to input values in the query whithout a value for "gruppeID"