[libreoffice-users] Re: Base clarity on external internal functionality

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: users+unsubscribe@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