Issue 108390 - "No data availlable" for subform
Summary: "No data availlable" for subform
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m9
Hardware: Unknown All
: P2 Trivial with 5 votes (vote)
Target Milestone: OOo 3.2.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
: 108377 108840 109298 111297 (view as issue list)
Depends on:
Blocks:
 
Reported: 2010-01-17 12:20 UTC by villeroy
Modified: 2010-05-02 15:29 UTC (History)
4 users (show)

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


Attachments
basic macro (14.57 KB, text/plain)
2010-02-11 18:53 UTC, drewjensen.inbox
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2010-01-17 12:20:55 UTC
Link to draft:
http://user.services.openoffice.org/en/forum/download/file.php?id=6481
Try internal form "New Invoice" or the same form on the spreadsheet linked to
registered "Invoices".
Created in 3.1.1, works in 2.4.3, population of subform fails with 3.2RC2 with
"No data availlable"
Comment 1 villeroy 2010-01-17 17:35:59 UTC
I removed RC2 and reverted to v3.1.1 in order to test the above linked database
with the version that has created the database.
The embedded form "New Invoice" does not work as intended since the subform is
bound through inappropriate fields. At least it works somehow without error.

The similar form attached to the spreadsheet does work with the intended subform
binding. Registration name is "Invoices" (proper cased).
Comment 2 r4zoli 2010-01-17 18:44:44 UTC
I can confirm, it works with 3.1.1 and not work with 3.2RC2 on linux.
Comment 3 drewjensen.inbox 2010-01-18 03:33:11 UTC
Confirmed on XP - Works with 3.0.1 [even]; does not with OOO320_RC2 or DEV300_69

The problem is with the master dataform having "add data only" set true it
seems, turn that off and the sub form displays data 
- but kind of kills the usefulness of the form IMO

Assign developer and set intitial target
Comment 4 Frank Schönheit 2010-01-19 09:10:24 UTC
you thankfully already have a fix for this ...
Comment 5 Frank Schönheit 2010-01-19 09:10:54 UTC
targeting to 3.2.1 - AFAIK, it has not been approved for 3.2.
Comment 6 ocke.janssen 2010-01-19 09:23:50 UTC
Fixed in cws dba321a
Comment 7 villeroy 2010-01-19 10:34:54 UTC
Marked as [issue] in the user forum:
http://user.services.openoffice.org/en/forum/posting.php?mode=edit&f=39&p=121142
Comment 8 ocke.janssen 2010-01-21 06:27:35 UTC
Please verify. Thanks
Comment 9 marc.neumann 2010-02-02 12:37:17 UTC
*** Issue 108840 has been marked as a duplicate of this issue. ***
Comment 10 Frank Schönheit 2010-02-04 21:46:56 UTC
*** Issue 108377 has been marked as a duplicate of this issue. ***
Comment 11 drewjensen.inbox 2010-02-11 18:52:57 UTC
Attached is a .bas file with a couple of routines to use as work arounds for this.

To use this - open your Base file, add if you need to, a basic library to the
file, copy the contents of the attachment into an empty module in the library.

The comments in the file should give you the information to make use of it.

For questions please use the mailing list users @ dba.openoffice.org or drop me
a direct email.
Comment 12 drewjensen.inbox 2010-02-11 18:53:32 UTC
Created attachment 67763 [details]
basic macro
Comment 13 drewjensen.inbox 2010-02-21 17:07:53 UTC
*** Issue 109298 has been marked as a duplicate of this issue. ***
Comment 14 marc.neumann 2010-03-26 14:09:37 UTC
verified in CWS dba321a

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba321a
Comment 15 drewjensen.inbox 2010-05-02 15:21:33 UTC
*** Issue 111297 has been marked as a duplicate of this issue. ***
Comment 16 drewjensen.inbox 2010-05-02 15:29:49 UTC
Checked this for the specific case of a single dataform, form, set for 'new
record only' with OOO320m_16 under Ubuntu and Vista. That works now, no problems.

Also checked DEV300m_77 under both OS - no problem.