Re: [dtp-dev] SQL statements don't work well.

["hosokawa" <hosokawa@xxxxxxxxxxxxxxxxx>]

Hi Hung,

In this case, should I report the point that termination character is not 
added by the DDL generator?

Best regards,

Takehiro Hosokawa
VALWAY Technology Center, NEC Soft, Ltd.


----- Original Message ----- 
From: <Hung.Hsi@xxxxxxxxxx>
To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
Cc: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>; 
<dtp-dev-bounces@xxxxxxxxxxx>
Sent: Wednesday, January 17, 2007 12:25 PM
Subject: Re: [dtp-dev] SQL statements don't work well.


> Hi Mr. hosokawa,
>
> Thanks for reporting the problem, please open a bugzilla entry.
>
> Regards,
> Hung
>
>
>
>             "hosokawa"
>             <hosokawa@xxxxxxx
>             .nec.co.jp>                                                To
>             Sent by:                  "DTP development mailing list"
>             dtp-dev-bounces@e         <dtp-dev@xxxxxxxxxxx>
>             clipse.org                                                 cc
>
>                                                                   Subject
>             01/16/2007 07:15          [dtp-dev] SQL statements don't work
>             PM                        well.
>
>
>             Please respond to
>              DTP development
>               mailing list
>             <dtp-dev@eclipse.
>                   org>
>
>
>
>
>
>
> Hi,
>
> On the SQL Editor, when I execute SQL statments like below, syntax error
> occurs.
>
> Executes SQL statements like:
>
>    CREATE TABLE test_table (
>            aaa INTEGER NOT NULL,
>            bbb CHAR NOT NULL
>        )
>    ALTER TABLE test_table ADD CONSTRAINT unq_bbb UNIQUE (bbb)
>
> Error occurs like:
>
>   "Syntax error: Encountered "ALTER" at line 5, column 1."
>
> Such a sequence, like CREATE TABLE and ALTER TABLE immediately, is not
> admitted?
> I checked they work well when CREATE TABLE statement and ALTER TABLE
> statement
> are executed separately like below exsample.
>
> Executes just CREATE TABLE first:
>
>    CREATE TABLE test_table (
>            aaa INTEGER NOT NULL,
>            bbb CHAR NOT NULL
>        )
>
> Executes ALTER TABLE next:
>
>    ALTER TABLE test_table ADD CONSTRAINT unq_bbb UNIQUE (bbb)
>
> I gotta "Succeeded" message at each time.
>
> Best regards,
>
> Takehiro Hosokawa
> VALWAY Technology Center, NEC Soft, Ltd.
>
> _______________________________________________
> dtp-dev mailing list
> dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
>
>
>
> _______________________________________________
> dtp-dev mailing list
> dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev