[KLUG Members] easy DB

[Adam Tauno Williams]

> > Or from any other ODBC tool on any platform. Using OOo for you forms and
> > scripting makes your solution entirely portable (since OOo runs and
> > supports ODBC on every major platform).
> Could you elaborate on the OOo stuff? The only feature I've found that
> uses is is the spreadsheet's Data Pilot, what MS Excel calls a pivot
> table. What else is in there, and where?

A good exmaple is -
http://documentation.openoffice.org/HOW_TO/data_source/how_to_link_tables_using_named_parameters.pdf
(Please understand there is NOTHING MySQL specific about this, it is
merely the database used in the example.  I've use this technique to
connect to both PostgreSQL and Informix [ a real $50,000 commercial
database ]).

Data pilot is cool too.  But the forms functionality doesn't get nearly
enough press.  This alone is enough to justify installing OOo, even if
you use M$-Office for everything else.