OO: 2.0.0 OS: MS Windows 5.1 (XP Professional) Can someone advise on the following questions:
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? 2. Where to find out the documentation of design logic for this additional restriction in OO Base GUI? 3. How to find out the version of HQLDB engine embedded in an OO Base installation? Thanks for help. R. Jahn --- description I have tested in the following 3 conditions: * HSQLDB 1.8.02 (without OO Base) through its Java module org.hsqldb.util.DatabaseManager * SQL interface (the CUI) of OO Base without going through the table wizard GUI * OO Base table wizard GUI The sample SQL code is provided below. The test results indicate that the OO Base GUI imposes additional requirement of unique key or primary key to permit table editing (entry, revision, etc.) through OO Base GUI. Such restriction is not present if one does not go through the OO Base GUI. SQL standards (SQL-92, SQL-99, SQL-2003) do not impose this restriction on table design either. --- SQL sample code -- OpenOffice 2.0.0 HSQLDB ? Create Table "tt entity" ( "ID numeric" Integer, "ID symbolic" VarChar( 50 ) Not Null, Constraint pk_tt_entity Primary Key ( "ID numeric" ), Constraint uq_tt_entity Unique ( "ID symbolic" ) ); Create Table "tt event type" ( "ID numeric" Integer, "ID symbolic" VarChar( 50 ) Not Null, Constraint pk_tt_evt_type Primary Key ( "ID numeric" ), Constraint uq_tt_evt_type Unique ( "ID symbolic" ) ); Create Table "tt event data" ( "event entity" Integer Not Null, "event type" Integer Not Null, "event date" Date Not Null, "event note" VarChar( 50 ), -- dummy column -- OO 2.0.0 requires unique key or primary key to permit table editing -- "event ID" BigInt Identity, Constraint fk_event_entity Foreign Key ( "event entity" ) References "tt entity" ( "ID numeric" ) On Update Cascade On Delete Restrict, Constraint fk_event_type Foreign Key ( "event type" ) References "tt event type" ( "ID numeric" ) On Update Cascade On Delete Restrict -- Constraint uq_evt_dummy Unique ( "event ID" ) ); -- SQL code to import contents into tables (the CUI approach) -- is snipped for brevity. -- Fill tables "tt entity" and "tt event type" before "tt event data". --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
