[dba-users] 1.9.130 show tables

[Ray Jahn]

OO: 1.9.130
OS: MS Windows XP

I am not sure whether this is a question for OpenOffice Base or
HSQLDB.  How could I make the SQL statement "Show Tables;" work in
OpenOffice?

-- test steps

Start OpenOffice Base 1.9.130
startup options
  create a new database
  do not register database
  open database for editing
  file name - your choice
Select the Tables icon in the left Database pane.

Tools - SQL - enter the following SQL code

press Execute button in SQL dialog
Command successfully executed - in status field, OK
close the SQL dialog

The newly created tables are not displayed yet in the main window.
menu command: View - Refresh tables
Should see the newly created tables - OK.

Right click the table "t junk".
Select option Edit.

 *** ***

I could not find a way to verify the the complete referential
constraint, especially the "On Delete" and "On Update" portions. 
(Also tried the SQL dialog in 1.9.130.)

Thanks for advice.

R. Jahn

-- OpenOffice 1.9.130 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, 1.9.130 requires unique index to permit table entry
 "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" )
);

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]