Andreas Saeger wrote:
> 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.
Thanks Andreas. I tried to follow your suggestion and created a query
following your model like this.
SELECT *, Charis("ENTRY Sorting") AS "Beaut" FROM "Table1"
Charis is the name of the macro and Entry Sorting is the name of a text
field in Table1 of the database. I got this as a result:
The data content could not be loaded.
Access is denied: CHARIS in statement [...]
The SQL command leading to this error is:
SELECT *, Charis("ENTRY Sorting") AS "Beaut" FROM "Table1"
Macro Charis is in the macros associated with this document.
Thanks,
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]
