Re: [libreoffice-users] Re: Another question concerning Base

On Mon, 20 Aug 2012 10:28:07 +0200
Alexander Thurgood <alex.thurgood@gmail.com> 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 :
>
> http://www.amazon.com/Database-Programming-OpenOffice-org-Base-Basic/dp/0557007585/ref=sr_1_11?ie=UTF8&qid=1345449641&sr=8-11&keywords=roberto+benitez
>
> Also check out Andrew Pitonyak's use of Basic with Base :
> http://www.pitonyak.org/database/
>
>
> If you can read German, I would suggest one of Thomas Krumbein's
> books :
>
> http://www.amazon.com/Datenbanken-mit-OpenOffice-org-Base-HSQLDB/dp/383621301X/ref=sr_1_4?s=books&ie=UTF8&qid=1345449757&sr=1-4&keywords=thomas+krumbein
>
> If you can read French, check out Laurent Godard/Bernard Marcelly's
> book :
>
>
> http://www.eyrolles.com/Informatique/Livre/programmation-openoffice-org-et-libreoffice-9782212132472
>
>
> The fact that most of the books/references above relate to
> OpenOffice.org 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.
>
>
> Alex

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

Tom

-- 
“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
linxt-At-comcast-DoT-net

-- 
For unsubscribe instructions e-mail to: users+help@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