What version of DTP are you using, and what database platform are you
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
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?
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:
> 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.