Andreas Saeger wrote:
> 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.
So it appears that, as I expected, I cannot use openoffice macros in
calculating fields in an openoffice database. I wonder what is the point of
enabling macro migration into an openoffice database in the first place.
Perhaps it's just for some simple formatting functions having nothing to do
with the fields themselves.
Thanks for the help.
Cheers,
Jonathan
--
Registerd Linux user #445917 at http://counter.li.org/
Please do not send me copies of list mail. I read the lists. Thanks!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
