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

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

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 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.


To unsubscribe 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.