> Where can I obtain the official COMPLETE syntax options for the SELECT > query that OpenOffice BASE readily accepts for use in ad hoc queries > (including some examples of correct usage using wildcards)?
There is some stuff at http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html. Click on SQL Syntax. I dont know how relevant this is vis a vis Ooo Cheers Gert > -----Original Message----- > From: Frank Schönheit - Sun Microsystems Germany > [mailto:[EMAIL PROTECTED] > Sent: Mon 21 November 2005 09:37 AM > To: [EMAIL PROTECTED] > Cc: [email protected] > Subject: [dba-users] Re: Where can I obtain the complete set > of allowed sytax options for the SELECT query in BASE? > > Hello Bill, > > I'm answering your mail in our project's users mailing list, > [EMAIL PROTECTED] Please note that this list is the > better place for questions as yours than mailing me directly. > This is a matter of scaling (more people than me could > potentially answer) and a matter of sharing knowlege (more > people than you could read the potential answer). > > I'd like to ask you to also reply to this list. You can post > to it without being subscribed, however your mails need to > pass moderation then, which can cause delays. Best way is to > subscribe to the list at > http://dba.openoffice.org/servlets/ProjectMailingListList. If > you prefer newsgroups over mailing lists: news.gmane.org > mirrors the list. > > > Where can I obtain the official COMPLETE syntax options for > the SELECT > > query that OpenOffice BASE readily accepts for use in ad > hoc queries > > (including some examples of correct usage using wildcards)? > > OpenOffice.org's built-in query parser accepts a sub-set of > SQL-92, with a few commont extensions. The complete set isn't > really documented (well, except in the code :-[ ), sorry. > > > > OpenOffice BASE seems to require some unusual form of SQL > syntax that > > does not seem to be the same standard used by HSQL, > Microsoft Access, > > Sybase, or Oracle. > > There is no "standard used by HSQL, Access, Sybase, or > Oracle" :) Every database engine extends the standard by a > lot of own elements, to reflect the capabilities of the > engine. Since OOo, before 2.0, was simply a front-end to > whatever database the user wanted to use, the built-in query > parser needs to adhere to some least common denominator. > With 2.0, OOo now uses HSQLDB as built-in default database, > but admittedly, our parser still does not cope with all of > HSQL's SQL features. > > > But OpenOffice doesn't seem to know what to do with INTO TEXT > > temptable in a SELECT statement. > > Which is one of the missing parts. In your query design, in > the SQL view, turn on the "Execute statement directly" button > in the toolbox. > This bypasses OOo's own query parser, and passes the > statement directly to the HSQLDB engine. > > > I particularly need to be able to combine the data from multiple > > fields of the same record in a table (with separating commas), into > > ONE temporary list field, to be the source for selecting > into only ONE > > field in an entirely different table. > > > > [BTW, the structure of SELECT DISTINCT "fieldname" FROM "tablename" > > "tablename" ORDER BY "fieldname" ASC in which the names > must be quoted > > and the tablename repeated seems unnecessarily awkward.] > > [The quoting is to bypass some potential, upper/lower-case > problems; the duplication of the table name is a reminiscence > to databases which need it - unfortunately we simply forgot > to turn it off for HSQLDB databases.] > > > [I'm studying the feasability of moving a single-user DB from > > Microsoft Access on a Windows PC eventually to OpenOffice on a Mac > > with OS 10, using OpenOffice on a PC as the intermediate > stage. The > > Access DB in question has no entry Forms but is loaded with table > > field queries and numerous ad hoc queries for specialized > extractions. > > Some very large tables consist entirely of fields related to and > > filled in by fields in other tables via pull-down list queries.] > > > > [Inserting large amounts of data into such an Access DB, > where most of > > the fields in a record grouping are the same, is more > easily achieved > > in a table format using the Ctrl-Quote feature in Access that > > automatically repeats the field immediately above.] > > > > > > > > Thank you. > > Bill [OpenOffice Member Login: bekozi] > > > Ciao > Frank > > (sorry to the netiquette for full-quoting even unreplied > parts of the mail, but I want to give readers in [EMAIL PROTECTED] a chance :) > > -- > - 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
