[michael_talavera]

Can you have a table alias in a sql editor and have the field assistance functionality work? For example, if I have a table scp_administration, I can have the following statement:

SELECT scp_administration.id, scp_administration.name
FROM scp_administration;

When I type the dot, the fields in that table are displayed in a list. This does not seem to work if the table has an alias, such as:

select a.id, a.name
from scp_administration a;

I complete the FROM clause first, then go back to the SELECT section, but the same field assistance does not seem to be available. Is the field assistance only available if you use the full table name?

Posting Guidelines:
– Operating System: Windows XP Professional
– Eclipse Version: 3.0.1 upgraded from 3.0.0 using the upgrade manager
– MyEclipse Version: 3.8.2 upgraded from 3.8.1 using the upgrade manager
– java.version=1.4.2
– Database is Oracle 9.2.0.1.0
– No errors in Eclipse log pertaining to this issue

[Riyad Kalla]

This is a known limitation, we parse the line in-order, so we don’t see the alias until the end.

[Author]

Posts