<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 - Subform Postgresql "The column index out of range: 1, number of columns: 0"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113617">113617</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Subform Postgresql "The column index out of range: 1, number of columns: 0
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.6.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>jeffsummer@mail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Cannot create a subform on a form in Base using postgresql tables connected
over jdbc, always shows the error: The data content could not be loaded." "SQL
Status: 22023 The column index is out of range: 1, number of columns: 0."
Steps to Reproduce:
1. Create two related tables in postgresql, as simple as relating the integer
field in a second table to the primary key integer field in the first table
2. Connect base to this postgresql database using jdbc
3. Create a new form, use the first table as the outer data source, the second
table as the subform data source, then use the integer field as the master and
slave link field, then run the form, at that point you get the error message
Actual Results:
error: The data content could not be loaded." "SQL Status: 22023 The column
index is out of range: 1, number of columns: 0." The main form gets data, the
subform does not
Expected Results:
A running form and subform
Reproducible: Always
User Profile Reset: No
Additional Info:
postgresql 9.6.4
postgresql-42.1.3.jar
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36</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>