Issue 113552

Summary: SubForms are not working at all in newer versions
Product: Base Reporter: wilq <wilczewski.piotr>
Component: MySQL Connector/OOoAssignee: dbaneedsconfirm <needsconfirm>
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Also discovered the same bug with internal database (simple stand alone file). Start forms.
none
suggested fix none

Description wilq 2010-07-30 20:02:33 UTC 
SubForms are always empty (no data). Main form is OK. Each type of subforms 
were tested (table, fields etc.) Previous versions of openoffice base are 
working correctly with the same odb file, same jdbc connector and same mysql 
database. The difference is only with OpenOffice version.

Using:
MySql 5.1.49 server on Windows XP SP3 server
JDBC mysql-connector-java-5.1.13-bin.jar connector
Open office base as the presentation layer

Please fix this asap since my application is not working at all without 
subforms after upgrade.
Comment 1 wilq 2010-07-30 20:15:16 UTC 
Created attachment 70894 [details]
Also discovered the same bug with internal database (simple stand alone file). Start forms.
Comment 2 wilq 2010-07-30 20:54:24 UTC 
sorry - the attachment is wrong.... Also shows no rows under OOo3.1.1 which 
works ok with the subforms.
Comment 3 Marcus 2010-07-30 23:01:51 UTC 
not a P1
Comment 4 drewjensen.inbox 2010-07-31 10:33:41 UTC 
@wilq I made two changes to the file using 3.2 - In the dialog
Edit>Database>Advanced Settings I disabled checking for required fields.

In the form I changed how the link was formed.

I'll attach the file, I think this is what you are looking for given the table
structure.
Comment 5 drewjensen.inbox 2010-07-31 10:34:13 UTC 
Created attachment 70904 [details]
suggested fix
Comment 6 wilq 2010-07-31 10:50:36 UTC 
Thanx. Unfortunatelly, as I wrote earlier this is not a problem in file but 
with MYSQL database. This does not solve that issue. Sorry for that attachement.
The problem still exists when connecting to the database. All the other forms 
are working all right, but subforms are not.... They remain always empty under 
version 3.2 or earlier. They are working very well until the version 3.1.1 and 
not any more.
Comment 7 r4zoli 2010-11-19 13:18:40 UTC 
duplicate

*** This issue has been marked as a duplicate of 113631 ***
Comment 8 r4zoli 2010-11-19 13:19:30 UTC 
duplicate -> Closing.