Le 04/08/2014 17:26, Paul D. Mirowsky a écrit : > It appears that external databases must use SQL to do things and that Base.
Not for everything, but your mileage as to what you can get out of LibreOffice's UI varies considerably depending on the db backend. > > Does this mean that the front end is no longer capable of displaying > 'Tables' and their linking? No, it means that it is dependent on the drivers that interface with the db to be precise about what they actually support (keys, constraints, referential integrity, etc). > Does this mean that 'Macro' commands no longer apply? Absolutely not, macros work on UI elements, preparedStatement objects, resultSets, rowSets, etc, in fact anything within LibreOffice's API and the corresponding db context. An example, you can set up an standalone Writer form that links to a mysql backend database, and have buttons on it that execute prepared statements or queries and then display the results or alter the content of the form/subform, etc. > > Is there a chart that can add some clarity as to what is functional and > isn't between the two? > Not that I know of, as it is dependent on the backend db / db driver configuration. For example, the general rule that binary large objects, other than images, can not be displayed via the default Base forms UI components prevails. Anything else requires programming via macro or scripting magic. A very useful book in this regard, available from Amazon, is Roberto Benitez' book to programming with OpenOffice.org Base. Another useful reference is Andrew Pitonyak's manual. These references give insights and code on manipulating the Base UI in ways akin to what is provided by default in Access, or FileMaker, Approach, etc. Alex -- To unsubscribe e-mail to: [email protected] 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
