Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

On Mon, 20 Aug 2012 10:28:07 +0200
Alexander Thurgood <> wrote:

Le 16/08/12 00:56, Thomas Taylor a écrit :

Hi Thomas,

When creating a table in Base with the wizard, is it possible to
use a boolean (yes/no) to control further input fields?  If so, how
please? my assumption is that entry conditional control must be
done without the wizard.

No, the wizard is not designed to let you do this, it will only do the
most basic of table creation tasks. Anything more sophisticated than
that would require programming skills and be dependent on the
functionality of the underlying database engine.

Note also that despite the possibility to enter data directly into a
Table View or Grid View (the terms often get mixed up together), the
LibreOffice API is documented as only supporting Form based
XBindableControls, i.e. there is no direct support for binding
controls, conditional or not, directly to the Table View that users
can use to enter data or when creating a new table in Table Design.

Confused ? You should be. ;-)

If you want an English book on programming with Base, look at Roberto
Benitez' book :

Also check out Andrew Pitonyak's use of Basic with Base :

If you can read German, I would suggest one of Thomas Krumbein's
books :

If you can read French, check out Laurent Godard/Bernard Marcelly's
book :

The fact that most of the books/references above relate to and not LibreOffice is not a major obstacle, there have
not been that many significant changes in the Base module behaviour
since the creation of the LibreOffice project :

- AOOo has moved its hsqldb engine to an improved version 2, whereas
LO is still stuck on version 1.8 ;

- AOOo has removed direct support for the mysql native connector due
to licensing issues, it is still provided as a download for older
versions of OOo, but is no longer being actively supported ;

- LO no longer has any actively supported native mysql connector
either, but for the moment, an attempt to not break the existing
external extension is being maintained ;

- LO has read/write native connector support for postgresql - this, I
believe, is a major improvement over AOOo, which only had read
support, and the postgres native connector is no longer even offered
with AOOo due to licensing issues ;

- both AOOo and LO support JDBC driver connections to postgresql and
mysql databases ;

- both AOOo and LO are supposed to support ODBC driver connections -
however, this is very dependent on OS, bit version architecture
(32/64) and buggy behaviours of the 3rd party drivers ;

- LO support of MS Access databases on Windows is variable according
to LO version and Access mdb/accdb version - one day it works with one
version of LO, the next it doesn't, so your mileage may vary - I can't
speak for AOOo here as I haven't tested that bit ;

- Access databases are not supported in either LO or AOOo on other
OSes (i.e. Linux/Mac), to my knowledge - these are usually dealt with
by 3rd party programs.

This is only a short comparison, I'm sure there are other points that
could be mentioned, but on the whole, the basic DB functionality
between the two is pretty much the same. That situation is likely to
change with the switch to LO version 4 development, where it has
already been decided that backwards version (ABI) compatibility for
all functionalities of the LO suite will not be guaranteed. At the
moment, I have no idea how that will affect Base, but it will almost
certainly affect any extensions that are currently available.


Thanks for all that information, Alex!  I'll look into getting one of
those books.


“What we do for ourselves dies with us. What we do for others and the
world remains and is immortal.”  Albert Pine
Tom Taylor - retired penguin
AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2
openSUSE 12.1x86_64    openSUSE 12.2x86_64
KDE 4.7.2, FF 7.0      KDE 4.8.4, FF 13.0
claws-mail 3.8.0
registered linux user 263467

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.