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

[Hung.Hsi@xxxxxxxxxx]

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