andrew wrote:
Hi,
I took the liberty of adding a page to the Base area of the wiki.
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures
Also updated the spreadsheet, available at my ftp server.
The function TRIM is now grouped with string functions, and I added
the statistical functions ( STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP ).
It could use some explanations and examples perhaps.
Drew
When I looked at the article, it seemed to be missing the "TRIM ( [" --
it started right off with LEADING, and had an extra | after BOTH. It's
also a bit confusing that LTRIM and RTRIM (and a number of other
functions) refer to s, while TRIM refers to <COLUMN>, with all of them
apparently wanting the name of a text field, enclosed in double quotes
if the field name is not all uppercase. How about
TRIM([LEADING | TRAILING | BOTH] FROM s)
The table cells for "Desinger" [sic], Parser, and Direct are not filled
in for the statistical functions. And I do think a little explanation
about context might be needed for those; I'm still not altogether clear
about how these columns relate to the possible contexts for issuing SQL
commands. Here's a stab at what I think might be a useful preliminary
statement (though I may well be misunderstanding this, I'm barely a
beginner here!)
SQL commands can be issued (a) using the Tools | SQL option of the main
Base window, or (b) from the Query Designer in Design view, using the
Edit | Run Query option, or (c) from the Query Designer in SQL view,
using the Edit | Run SQL command directly option, or the equivalent
toolbar icon. The Query Designer is only intended for commands that
prepare a result set of data for viewing or editing (i.e., for SELECT
commands). For commands in one of these contexts, the tables below
indicate which functions can be included in the command. Designer
indicates context b; Parser indicates context a; and Direct indicates
context c.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
