[libreoffice-users] Re: LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

Le 23/02/2014 16:05, Jim Seymour a écrit :


Hi Jim,

> A sub-form would (could?) be presented, allowing one to alter the
> status table.
>
> Btw: When I try to associate hdwr_assets.status_id to
> hdwr_status.status_id using the Forms Wizard, execution results in
>
>     Error: The data content could not be loaded.
>     Error: SQL Status: 22023
>      The column index is out of range: 1, number of columns: 0.
>     Information: The SQL command leading to this error is:
>
>      SELECT * FROM "public"."hdwr_status" WHERE ( "status_id"
>      = :link_from_status_id )
>
> Which is not valid SQL.

I just found this :

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=47100

where others are having the same problem, and which goes back initially
to 2012, and concerns Apache OpenOffice, but much of the code (and
unexpected behaviour) like that reported here, is still shared with
LibreOffice. Independent developments in the LibreOffice code have
further compounded, or added to, the existing bugs.

It doesn't look like this particular question was solved, at least the
question hasn't been marked as such, but it does suggest to set up the
form and subforms manually rather than by using the subform wizard.

Alex Thurgood



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted