menu:Insert>Query (SQL)...
SELECT *, UPPER("Name") AS "NAME" FROM "Your Table"
Selects all the fields from a table named "Your Table" plus a calculated
field labeled "NAME" having the upper cased value of a text field named
"Name".
Just replace the quoted object names with you actual ones.
This type of query is very easy to write directly as SQL statement. You
can switch to the graphical view in order to see how to compose it in
that tool.
However: The graphical designer can not handle more SQL than you are
able to learn on a lazy afternoon. SQL lets you operate *every*
relational database with very few differences in syntax and functionality.
With the bare minimum of SQL in your head and some decent text editor
at hand you can work around many limitations in Base.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
