<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Firebird main-form to sub-form data content not loading."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119911">119911</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Firebird main-form to sub-form data content not loading.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>cesl@bellsouth.net
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>