Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Builder to produce "As"-less alias?
SQL Builder to produce "As"-less alias? [message #631526] Thu, 07 October 2010 20:22 Go to next message
Chauncey Xu is currently offline Chauncey XuFriend
Messages: 12
Registered: October 2010
Junior Member
I'm using the DTP SQL builder and ran into a problem. If I have an existing sql statement with table alias

Select *
From Employee E

And I edit it in the SQL builder, the keyword AS will be inserted after the edit, so I get

Select *
From Employee AS E

Does the SQL builder has a switch to make AS-less alias?

Thanks!
Re: SQL Builder to produce "As"-less alias? [message #632665 is a reply to message #631526] Wed, 13 October 2010 19:27 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
What version of DTP are you using, and what database platform are you
connecting to?

We put in a fix in DTP 1.8.1 so that the SQL Query Builder doesn't
generate the AS keyword for table correlation IDs when connected to an
Oracle database.

On 10/7/2010 1:22 PM, chauncey wrote:
> I'm using the DTP SQL builder and ran into a problem. If I have an
> existing sql statement with table alias
>
> Select * From Employee E
>
> And I edit it in the SQL builder, the keyword AS will be inserted after
> the edit, so I get
>
> Select * From Employee AS E
>
> Does the SQL builder has a switch to make AS-less alias?
>
> Thanks!
>
Re: SQL Builder to produce "As"-less alias? [message #632671 is a reply to message #632665] Wed, 13 October 2010 20:14 Go to previous messageGo to next message
Chauncey Xu is currently offline Chauncey XuFriend
Messages: 12
Registered: October 2010
Junior Member
Brian,

I'm using version 1.6.2, and unfortunately I'm not able to upgrade at this moment. Is there a workaround I can opt for?

Yup, Oracle database is what's causing all these.

Great you have a solution in 1.8.1 though.
Re: SQL Builder to produce "As"-less alias? [message #632927 is a reply to message #632671] Thu, 14 October 2010 16:58 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
Well, if you are set up to build DTP, you can apply the patch in bug
319927 to the plugin org.eclipse.datatools.sqltools.sqlbuilder. It will
probably apply to the 1.6.2 version without a problem.

I can't think of much else that would fix the problem in 1.6.2.

On 10/13/2010 1:14 PM, chauncey wrote:
> Brian,
> I'm using version 1.6.2, and unfortunately I'm not able to upgrade at
> this moment. Is there a workaround I can opt for?
> Yup, Oracle database is what's causing all these.
>
> Great you have a solution in 1.8.1 though.
Previous Topic:ClassCastException on JDBCView.createSupertableLoader() and JDBCTable.createSupertableLoader()
Next Topic:DTP 1.8.2 - regeneration of Sybase Ecore models and model code
Goto Forum:
  


Current Time: Thu Mar 28 15:57:11 GMT 2024

Powered by FUDForum. Page generated in 0.07555 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top