Hi Raw, > 1. How to turn off the requirement of unique key or primary key, as > imposed in OO Base GUI, just before saving a newly designed table?
You cannot. For determining which row to update/insert in a table, OOo needs to uniquely identify this row - this is what a primary key / unique index is good for. You can still create tables without PK/UI, but then you cannot update/add data. Note that there are some backends which support data update even without primary keys, for instance OOo's dBase implementation. This is because those backends support another method of uniquely identifying a row within a table, so-called bookmarks. However, if your backend doesn't support this - and HSQLDB, OOo's default backend doesn't -, then you need a PK. > 2. Where to find out the documentation of design logic for this > additional restriction in OO Base GUI? in the two paragraphs above :) IIRC there's an FAQ entry explaining this, too. > 3. How to find out the version of HQLDB engine embedded in an OO Base > installation? The ugly way: Unzip your .odb file, and look into the database/properties file. There's probably a runtime-way, too ... Ciao Frank -- - 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]
