Issue 109898 - oForm.insertRow() doesn't work correct
Summary: oForm.insertRow() doesn't work correct
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on: 111205
  Show dependency tree
Reported: 2010-03-07 14:26 UTC by robbygro
Modified: 2013-01-29 21:47 UTC (History)
3 users (show)

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

insertRow() in a subform (13.17 KB, text/plain)
2010-03-07 14:58 UTC, robbygro
no flags Details
try to input values in the query whithout a value for "gruppeID" (14.16 KB, application/vnd.sun.xml.base)
2010-04-30 19:05 UTC, robbygro
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

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
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"