Hi Andreas, > Now I discovered something completely new to me. With "simple sources" > (imported from csv, spreadsheet, dBase and alike) I used to use the > query designer or SQL in "non-native" mode. The only function availlable > is COUNT(*) to get the row count. On several occasions I wrote on > oooforum.org that there is no other function availlable with this kind > of data source. I was plain wrong. Switching to native mode you get the > functions described here: > http://dba.openoffice.org/specifications/file_based_functions.html > Well hidden, isn't it?
You can use all those functions in the graphical designer, too. The reason they don't appear in the "Function" list is that this list contains aggregate functions only. This is true for dBase/text/Calc as well as for all other database types, just that dBase/text/Calc support only one aggregate function, but much more other functions. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
