Re: [dtp-dev] Table Manipulation Design document draft

["hosokawa" <hosokawa@xxxxxxxxxxxxxxxxx>]

Hi Anthos,

Thank you. I tried SQL Developer and I could get a image well.
And I have another question.
How can I create multiple tables simultaneousely using such multi tabbed 
page?
It seems that tables are created one by one even if using such GUI, like SQL 
Developer.
I'm sorry if I have misunderstanding......

> 3. It will be good to have multi(tabbed) page rather than a dialog to 
> modify
> the structure of newly creating table. This would allow user to create 
> multiple
> tables simultaneously, copy/paste text back and forth and so on.

Best regards,

Takehiro Hosokawa
VALWAY Technology Center, NEC Soft, Ltd.

----- Original Message ----- 
From: "Anil T Samuel" <anil.samuel@xxxxxxxxxx>
To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
Sent: Monday, November 13, 2006 10:56 AM
Subject: Re: [dtp-dev] Table Manipulation Design document draft


> Hi
>
> 1. Check out "SQL Developer" from oracle at 
> http://www.oracle.com/technology/software/products/sql/index.html. Try 
> Create Table with "Advanced" option checked and select "Foreign Keys" on 
> left side.
>
> 2. Each tab in this case could correspond to a left side option mentioned 
> above. One tricky bit will be to have dependency maintained in the 
> generated DDL script so that 'dependees' are created before 'depender'.
>
> Anthos
>
> hosokawa wrote:
>
> > Hi Anthos,
> >
> > Thank you for great suggestions to bug:162519 
> > (https://bugs.eclipse.org/bugs/show_bug.cgi?id=162519
> > ).
> > Could you tell me if you know good examples of GUI design for 1 and 3?
> >
> > > 1. It will be good to have the interface to support creation of 
> > > referential
> > > child relations as well; ie, sql equivalent of
> > > CONSTRAINT person_address FOREIGN KEY("homeaddress") REFERENCES 
> > > address("id"
> > > ENABLE
> > >
> > > 3. It will be good to have multi(tabbed) page rather than a dialog to 
> > > modify
> > > the structure of newly creating table. This would allow user to create 
> > > multiple
> > > tables simultaneously, copy/paste text back and forth and so on.
> >
> >
> > Do you mean each tabbed page has each database table's structure to 
> > modify
> > and a new page is added to create a new table?
> >
> > Best regards,
> >
> > Takehiro Hosokawa
> > VALWAY Technology Center, NEC Soft, Ltd.