Mailinglist Archive: opensuse (1355 mails)

< Previous Next >
[opensuse] Can't make Libre Office Base work
Hi,

I'm trying again LO Base against an existing database in MySQL. Things
have improved, but not enough to make it work.

First main improvement is that it LO now connects directly without using
things like ODBC or JDBC. Wonderful.

I can see my database:

<http://paste.opensuse.org/64191135>

But as you can see in the table view:
<http://paste.opensuse.org/77063841>

columns such as "author" or "Genre" display the index numbers, not the
corresponding names.

This is how it displays in Rekall - correctly:

<http://paste.opensuse.org/25141180>


I look around menus in LOB and I find in tools "Relations". Wonderful! I
simply need to define the relationships between the several tables. In
less than a minute I define the first one, in the familiar method I used
in Windows decades ago and that Rekall also used:

<http://paste.opensuse.org/65162073>

There is a little problem, it seems to link index to index, while it
should be "autor" in the left to "indice" in the right. I fiddle a bit
and try to edit the relationship:

<http://paste.opensuse.org/35000587>

Sure enough, the relationship is not correct. I change it.

<http://paste.opensuse.org/75355788>

BUT! The OK button does nothing. I have to press cancel to exit. The
line connecting the tables disappear:

<http://paste.opensuse.org/58564267>

And trying to connect them again fails. No error, simply ignores me. I
can click on Relationships again, and the box is empty.

How is this supposed to work?


Is Libre Office Base finished? I have been waiting for this feature in
Linux since 1998, when I used it in Windows Office and worked instantly.
Rekall in KDE3 did it fine, but Rekall is no longer provided in openSUSE.


In fact, in order to take the photos for this post and show the line
connecting the relationship I have to exit LO and delete the created
file. It only draws the line the first time I try, not the next times.


Yes, I have looked in LO help. Useless. No howto. I don't understand a
word of it.


--
Cheers / Saludos,

Carlos E. R.
(from 42.3 x86_64 "Malachite" at Telcontar)

< Previous Next >