[Libreoffice-bugs] [Bug 119911] New: Firebird main-form to sub-form data content not loading.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119911

            Bug ID: 119911
           Summary: Firebird main-form to sub-form data content not
                    loading.
           Product: LibreOffice
           Version: 6.1.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cesl at bellsouth.net

Description:
When using a main-form and a subform; firebird_sdlbc not loading the data
content.   

Steps to Reproduce:
1.Create main table for main form using the create table in design view.  the
values are as follow in sql;
Create test (
t_id integer primary key,
testadmin varchar(100)
);
2.Create sub table for sub form sql using the create table in design view.  the
values are as follow in sql;: 
Create testrecords (
tr_id integer primary key, 
t_id2 integer references test(t_id),
tdesc varchar(100), 
tdate date
);
3. Click Tools in the tools menu and select relationship. 
4. Click Insert in the tools menu and select add tables.  Select table test &
testrecords.  
5. Link t_id to t_id2
6. Save
7. Go to forms and click use wizard to create forms. select table test as main
form and add all the fields to fields in form option. 
8. Click Next.
9. Click add subform 
10. Click next
11. select testrecords as subform and add all the the fields to the field in
form option. 
12. Click next
13. select t_id in first join main form field.
14. selct t_id2 in first join subform field.
15. click next
16. finish.

Actual Results:
When opening the form. Window pops up with the following message.

The data content could not be loaded.
firebird_sdbc error: 
*dynamic sql error
sql error code = -206
colomn unknown
link from ----
at line 1, column 
caused by isc_dsql_prepare

Expected Results:
main form displays subform content. 


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180916/9146ffde/attachment.html>