Hi Frank, > Those functions are not supported at the moment. The csv/spreadsheet > driver in OOo uses Base's own "query engine", which simple does not know > about those (and nearly all other) functions. HSQL uses its own query > engine, which does.
Ok. > For csv, you might consider using the text table feature of HSQL, which > allows you to link csv files as tables into a HSQL DB. See the "Text > Tables" section at hsqldb.org's documentation site - or perhaps somebody > here knows of another/better documentation? I've found this entry in the wiki : http://wiki.services.openoffice.org/wiki/HSQL_Text_Table_Integration According to the spec, there is some UI feedback about linked text table but I didn't find it neither on OOo Base 2.4 nor OOo Base 3.0 ? So, I'll have to try with SQL statement : http://hsqldb.org/doc/guide/ch06.html Thank you, best regards. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
