| Multiple Statement Delimiter [message #51451] |
Wed, 12 November 2008 14:39  |
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 #51558 is a reply to message #51533] |
Thu, 13 November 2008 15:55  |
| 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 |
| 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 |
| Eclipse User |
|
|
|
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 |
| 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 :-)
|
|
|
Powered by
FUDForum. Page generated in 0.04984 seconds
Home