FamiliaFrazelle wrote: > Frank Schönheit - Sun Microsystems Germany wrote: >> Hi, >> >> >>> Up to now, i haven't been able to open the query in Edit mode and >>> insert a calculated field or column. Is this possible? >>> >>
I drop the query designer all together. I create all queries in SQL view with native mode turned on. This way I can use JOINS and all the functions documented in http://hsqldb.org/web/hsqlDocsFrame.html 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? Now I have a question: Why using non-native mode at all? Is there any scenario where you need to use that mode? SQL is really simple and I can edit all SQL in a decent editor easier than in that GUI. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
