[bpdahm]

– System Setup ——————————-
Operating System and version: Windows 200 Professional
Eclipse version: 3.0.2
Eclipse build id: 200503110845
Fresh Eclipse install (y/n): y
MyEclipse version: 4.0 Milestone 1
Eclipse JDK version: 1.4.2

If this is a DB related question please answer the following:

RDBMS vendor and version: Informix

Hi,

is there any way to work with a table field completion and synonyms ??

I try to complete the following sql and it does not work because of the synonym per

select * from person per where per. <— no completion of the synonym

It just works with this syntax

select * from person where person. <– completion works properly

But this is no alternative way to work within complexe sql statemants

Regards

Peter

[Riyad Kalla]

I believe this is on our TODO list but I will check with the developer.

[support-jeff]

There is an issue in bugzilla on this, but it is very low priority. Mainly it is to do with the difficulty of dynamically dealing with the auto-completion of an alias, plus the fact that a table alias is not declared until the from clause, which means you could never auto-complete in the select clause, etc. Very thorny one.

[bpdahm]

I can imagine that it is a tricky problem. But it is more than usefull within complex databases and complex sql statements. i now that some of my collegues are using other tools because of this feature.

Hopefully you will find out a solution for this problem.

Regards

Peter

[support-jeff]

I should clarify that it is not a low priority because of the difficulty of implementing, but rather it has never been a highly requested item (this is quite literally the second or third request).

[Riyad Kalla]

Second request 🙂

[Jose.Lora]

Third request. This is an old one and I cannot imagine people doing serios SQL work not wanting a feauture like this one.

Any idea when will this be implemented?

Thanks

[Author]

Posts