[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 )

How are your table indexes defined ? Are they "multiple column" indexes?

Which type of UI control are you using in your form to display the
result - Combobox or ListBox ?

You might be better off trying to do this manually rather than via the
wizard, i.e. in Form design mode using the Form Navigator to create your
subforms and then binding the corresponding data fields to UI controls,
as the subforms wizard hasn't always produced the expected results
throughout the various versions of LO.

At the moment, I can't tell whether this is a bug in the version of LO
that you are using, or whether it is a combination of other factors
(type of UI control in form, binding of data field to UI control, etc).


Alex T



-- 
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