Hi Aladdin, > I was wondering what is the status for built-in functions in database from > csv/spreadsheet ? > > For example, > CASEWHEN / CASE WHEN didn't work in sql statement when you use a database > from > csv/spreadsheet but it's ok when you use an embedded hsqldb. > > Any tips ?
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. 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? 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]
