Alan Boba wrote:
On Dec 18, 2007 6:02 PM, Dorian Sabaz <[EMAIL PROTECTED]> wrote:
First, where can I find a reference for the supporting Functions in your
Query maker.
There is a listing of functions available at
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures
For this items listed on the wiki there is more detail then in the
hsqldb documents, there are a group of functions and procedures that
have not been added yet however. Such as "Case When" and a few others
along those lines.
The supported functions in Query builder are those that are offered in the
"Function" row of the interactive query interface. They are only a subset of
the functions available in the HSQL product. To perform the other functions
it will be necessary to use the SQL statement window available via the Tools
SQL... menu option.
Sorry but that is just incorrect. - almost all functions are supported
in the GUI query designer. The drop down list you reference are only a
limited group of aggregate functions. For most functions they are simply
used in the column selection area. In the case of those that are not
supported in the GUI designer then they are supported in the text based
query design window and a few require that escape processing be turned
off - but none of them require the use of the SQL window. Using the SQL
window does not allow anyone to save the query for later use, whereas
using the text based query design window, even if escape processing is
disabled, still allows the query to be saved and referenced later.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]