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

Le 22/02/2014 19:11, Jim Seymour a écrit :

Hi Jim,

> For starters: LibréOffice 3.5.7.2, Build ID: 350m1 (Build: 2)
>
> Before anybody suggests a newer version: I'm currently on Ubuntu
> 10.04 LTS (Lucid Lynx), so I'm stuck with it.  (Even my much newer
> Linux Mint desktop install at work is still 3.x, I believe.)

You should be able to install newer versions even on Ubuntu 10.04 LTS,
if you download them from the LibreOffice website. Of course, they won't
necessarily have full desktop integration, although Unity came after
10.04, so it should be OK.

As for Linux Mint, I have Mint 15 and 16 on two separate machines. Both
have (at least I think they do) more recent packaged versions of LO in
their repos than 3.5.7 (Mint 16 : LO 4.1.3.2). Anyway, as that is not
necessarily an immediate solution to your problem, on to the meat of the
question :


> I have a database with a couple tables, as in
>
> create table hdwr_assets (
>   atag           text primary key,
>   serno          text unique,
>   status_id      int references hdwr_status,
>   . 
>   .
>   .
> );
>
> -- e.g.: "deployed", "in stock"
> create table hdwr_status (
>   status_id serial  primary key,
>   descr     text    not null,
> );
>
> The plan was to create a form that could query and alter hardware
> assets, selecting values for status_id from a drop-down list, the
> available selection being from the hardware status table.

Does the LEFT JOIN query with a single join actually run from the Query
Designer or do you get an error ?

Does it make any difference if you turn off/on the Direct SQL button
(which causes the query to bypass the internal LO SQL parser, or
alternatively, ask it to interpret the query before fielding it to the
JDBC driver) ?

What are the settings in the "Advanced Options" of your db connection
for that ODB file ?

Which driver version of JDBC are you using ?
Which version of postgres ?

Alex (yes, yet another)




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