All Forums Tools
thomandl 2 posts Joined 05/12
11 Dec 2012
Eclipse / Teradata Studio Express Code Assist

Hi all,
i have a problem with the Code Assist in Eclipse and Teradata Studio Express. 

--Work correctly 

select * from db.table where db.table.

-Doesn't work

select * from db.table as a where a.

Have anybody in idea how to fix that? The settings in Eclipse are OK i think. All options at "Preferences/Data Management/SQL Development/SQL editor/Code assist" are checked. Are there settings on other places that have to be modified?
Best regards Johannes

Chuckbert 78 posts Joined 07/09
12 Dec 2012

The code assist doesn't deal with such aliases as your second statement contains. It basically understands what types of database objects (tables, columns, etc.) are valid at the insertion point. It offers choices of names of such objects that are contained in the database object whose name is before the dot. 
The editor doesn't maintain the semantic meaning of tokens such as your "a" that are defined only in the context of the SQL statement. It only deals with objects defined within the database. There are no settings to make that will make the editor's code assist deal with aliases.

thomandl 2 posts Joined 05/12
14 Dec 2012

Thanks chuckbert. That aren't good news!

You must sign in to leave a comment.