Jonathan Kaye wrote:
Andreas Saeger wrote:
menu:Insert>Query (SQL)...
SELECT *, UPPER("Name") AS "NAME" FROM "Your Table"
SELECT *, Charis("ENTRY Sorting") AS "Beaut" FROM "Table1"
SQL is not a programming language. It is more like a command line
environment to manipulate most relational databases on the market. By no
means it is related to macros.
One of hundreds of SQL turorials: http://www.1keydata.com/sql/sql.html
Using Base you are working with 2 applications at the same time. The
self-contained database you can create newly from scratch is based on a
database engine, fully documented at http://hsqldb.org/doc/guide/ch09.html
This database engine provides the tables, relations and most of the
availlable functions.
The second application is OpenOffice.org which provides a simplistic GUI
for the database engine, shows database contents in grid views and lets
you create input forms and reports based on office documents.
Tools>SQL... is the direct command line to manipulate the connected
database structure and modify data.
The query designer provides a command line to read content from the
connected database.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
