On Mon, 20 Aug 2012 10:28:07 +0200 Alexander Thurgood <alex.thurg...@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+h...@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