Hi Andrew, Hi Gary, > Unless you have a primary key on a table you cannot use functions on a > column in a query. The exception to this should be COUNT, if you have a > named range in your spreadsheet then you should see this function available.
Uhm, sorry, but functions and primary keys are completely unrelated. Which of the functions appear in the query design depends on "database engine". For Spreadsheets, this basically means it depends on the component (the driver) which translates a spreadsheet into database-like data. However, I'm surprised that only "no function" is shown - at least "Count" should be (and for me: is) available. gary, feel free to submit a request for enhancement in IssueZilla requesting more functions - I fear at the moment it's simply not possible to use anything except Count. > I believe this is due to a design choice made in the HSQLDB engine and > not OO.o, per se, since Base is really just a wrapper around whichever > engine you choose to use. The availability of functions is also not related to the HSQLDB engine - HSQLDB and the Spreadsheet driver are completely independent. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
