Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Completion in DTP 1.6RC1
SQL Completion in DTP 1.6RC1 [message #591238] Mon, 26 May 2008 19:39
Stephen Schaub is currently offline Stephen SchaubFriend
Messages: 13
Registered: July 2009
Junior Member
Eclipse 3.3.2 on XP SP2 with DTP 1.6.0 RC1 and DB2 8.1

I am having some limited success with SQL completion in the SQL editor.
However, I am hoping for more, and wondering if the tool is functioning as
designed.

In the following query:

SELECT *
FROM AA.BBBB

... when I type this much

SELECT *
FROM AA.^

(^ indicates cursor location) I get a list of table names in the AA
schema. That's nice. However, if I just type

SELECT *
FROM ^

and request completion, I don't get a list of schema names or tables. Is
there a way to request a list of schema names? Even better, I would like
to see a list of tables in the current schema. But I don't see a way to
set a current schema for the editor.

Regarding column completion, when I type the following:

SELECT AA.BBBB.^
FROM AA.BBBB

and press Ctrl+Space at the ^ I get a list of column names in table BBBB.
However, when I request completion at the following location:

SELECT ^
FROM AA.BBBB

I get nothing. I would expect to see a list of columns from the tables in
the FROM clause - ?

By the way, I love the simplified connection profile creation in 1.6. A
vast improvement over earlier versions.
Previous Topic:Oracle
Next Topic:Running multiple sql commands
Goto Forum:
  


Current Time: Sat Dec 20 10:27:06 GMT 2014

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

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