facebook

auto completion suggestion in the SQL editor

  1. MyEclipse IDE
  2.  > 
  3. Feature Requests
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #250859 Reply

    I just upgraded to 4.1.1 and I was checking out the auto completion in the SQL browser. I have a request.

    The hardest thing to remember when type sql is column names. How about supporting table aliases? If I define a table alias and then type the table alias in other parts of the SQL statement, pop-up the column names. For example, if I have the following sql statement:

    select i.sku, i.name from item i where i.sku = ‘20000’;

    When I type “i.”, pop-up a list of the columns. If I type “i.a”, narrow the list to column names that start with “a”.

    Thanks

    #250936 Reply

    Riyad Kalla
    Member

    We have wanted to add this for a long time, was just an issue of management prioritizing the work to go back into the parser and add seek-ahead support for the alias to provide the autocomplete. I’ll try and bump this.

    #341294 Reply

    Michael A. McAngus
    Participant

    @support-rkalla wrote:

    We have wanted to add this for a long time, was just an issue of management prioritizing the work to go back into the parser and add seek-ahead support for the alias to provide the autocomplete. I’ll try and bump this.

    It’s over 7 years later. I’d like to +1 this request.

    #341322 Reply

    support-swapna
    Moderator

    mmcangus,

    The feature is available in MyEclipse Visual SQL Query Editor. Open the .sql with ‘MyEclipse Visual SQL Query Editor’ and you can see auto complete suggestion for table alias. Please try it out.

    Please refer to this tutorial for an overview about MyEclipse Visual SQL Query Editor :
    http://www.myeclipseide.com/documentation/quickstarts/vqb_overview/

    Let us know if you see any issues.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: auto completion suggestion in the SQL editor

You must be logged in to post in the forum log in