Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Multiple Statement Delimiter
Multiple Statement Delimiter [message #51451] Wed, 12 November 2008 14:39 Go to next message
Eclipse User
Originally posted by: nowhere.a.com

I am using MS SQL 2005

When I try to delete a table, the following SQL is generated:

ALTER TABLE agency DROP CONSTRAINT PK_agencyGO
DROP INDEX I_agencyGO
DROP TABLE agencyGO

As you can see, the word GO is appended without any white space. I have
looked through the property pages but I cannot find where this is set.

At any rate, the word GO should be a semi-colon.

Eclipse 3.4 WPT 2

--
Wojtek :-)
Re: Multiple Statement Delimiter [message #51506 is a reply to message #51451] Wed, 12 November 2008 19:06 Go to previous messageGo to next message
Eclipse User
Originally posted by: nowhere.a.com

Wojtek wrote :
> I am using MS SQL 2005
>
> When I try to delete a table, the following SQL is generated:
>
> ALTER TABLE agency DROP CONSTRAINT PK_agencyGO
> DROP INDEX I_agencyGO
> DROP TABLE agencyGO
>
> As you can see, the word GO is appended without any white space. I have
> looked through the property pages but I cannot find where this is set.
>
> At any rate, the word GO should be a semi-colon.
>
> Eclipse 3.4 WPT 2

And further, the line:
DROP INDEX I_agencyGO
should be
DROP INDEX agency.I_agency;

--
Wojtek :-)
Re: Multiple Statement Delimiter [message #51533 is a reply to message #51506] Thu, 13 November 2008 13:37 Go to previous messageGo to next message
Eclipse User
Originally posted by: brianf.sybase.com

This will be fixed when a huge patch gets applied for DDL generation to MS
SQL Server support in Galileo. In Ganymede and earlier versions, we didn't
have MSSQL-specific DDL support. There's definitely a few warts there.

You can apply the patches from http://bugs.eclipse.org/250302 yourself if
you want to check them out. They may not be perfect yet, but it's a huge
improvement from where we are currently (thanks to the nice guys at NexB).

--Fitz

"Wojtek" <nowhere@a.com> wrote in message
news:mn.63c67d8b6b0bdd62.70216@a.com...
> Wojtek wrote :
>> I am using MS SQL 2005
>>
>> When I try to delete a table, the following SQL is generated:
>>
>> ALTER TABLE agency DROP CONSTRAINT PK_agencyGO
>> DROP INDEX I_agencyGO
>> DROP TABLE agencyGO
>>
>> As you can see, the word GO is appended without any white space. I have
>> looked through the property pages but I cannot find where this is set.
>>
>> At any rate, the word GO should be a semi-colon.
>>
>> Eclipse 3.4 WPT 2
>
> And further, the line:
> DROP INDEX I_agencyGO
> should be
> DROP INDEX agency.I_agency;
>
> --
> Wojtek :-)
>
>
Re: Multiple Statement Delimiter [message #51558 is a reply to message #51533] Thu, 13 November 2008 15:55 Go to previous message
Eclipse User
Originally posted by: nowhere.a.com

Brian Fitzpatrick wrote :
> This will be fixed when a huge patch gets applied for DDL generation to MS
> SQL Server support in Galileo. In Ganymede and earlier versions, we didn't
> have MSSQL-specific DDL support. There's definitely a few warts there.

Thanks. Good news

--
Wojtek :-)
Re: Multiple Statement Delimiter [message #593885 is a reply to message #51451] Wed, 12 November 2008 19:06 Go to previous message
Eclipse User
Originally posted by: nowhere.a.com

Wojtek wrote :
> I am using MS SQL 2005
>
> When I try to delete a table, the following SQL is generated:
>
> ALTER TABLE agency DROP CONSTRAINT PK_agencyGO
> DROP INDEX I_agencyGO
> DROP TABLE agencyGO
>
> As you can see, the word GO is appended without any white space. I have
> looked through the property pages but I cannot find where this is set.
>
> At any rate, the word GO should be a semi-colon.
>
> Eclipse 3.4 WPT 2

And further, the line:
DROP INDEX I_agencyGO
should be
DROP INDEX agency.I_agency;

--
Wojtek :-)
Re: Multiple Statement Delimiter [message #593909 is a reply to message #51506] Thu, 13 November 2008 13:37 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
This will be fixed when a huge patch gets applied for DDL generation to MS
SQL Server support in Galileo. In Ganymede and earlier versions, we didn't
have MSSQL-specific DDL support. There's definitely a few warts there.

You can apply the patches from http://bugs.eclipse.org/250302 yourself if
you want to check them out. They may not be perfect yet, but it's a huge
improvement from where we are currently (thanks to the nice guys at NexB).

--Fitz

"Wojtek" <nowhere@a.com> wrote in message
news:mn.63c67d8b6b0bdd62.70216@a.com...
> Wojtek wrote :
>> I am using MS SQL 2005
>>
>> When I try to delete a table, the following SQL is generated:
>>
>> ALTER TABLE agency DROP CONSTRAINT PK_agencyGO
>> DROP INDEX I_agencyGO
>> DROP TABLE agencyGO
>>
>> As you can see, the word GO is appended without any white space. I have
>> looked through the property pages but I cannot find where this is set.
>>
>> At any rate, the word GO should be a semi-colon.
>>
>> Eclipse 3.4 WPT 2
>
> And further, the line:
> DROP INDEX I_agencyGO
> should be
> DROP INDEX agency.I_agency;
>
> --
> Wojtek :-)
>
>
Re: Multiple Statement Delimiter [message #593920 is a reply to message #51533] Thu, 13 November 2008 15:55 Go to previous message
Eclipse User
Originally posted by: nowhere.a.com

Brian Fitzpatrick wrote :
> This will be fixed when a huge patch gets applied for DDL generation to MS
> SQL Server support in Galileo. In Ganymede and earlier versions, we didn't
> have MSSQL-specific DDL support. There's definitely a few warts there.

Thanks. Good news

--
Wojtek :-)
Previous Topic:Executing SQL statement
Next Topic:NPE when trying to work on SQL file
Goto Forum:
  


Current Time: Thu Jul 31 05:34:06 EDT 2014

Powered by FUDForum. Page generated in 0.03021 seconds