Unsupported Screen Size: The viewport size is too small for the theme to render properly.

More Advanced Auto Complete

forums › forums › SQLyog › SQLyog Comments › More Advanced Auto Complete

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 8, 2007 at 2:22 am #10537
      stpin00
      Member

      I'd like to see a more advanced auto complete in SQLyog. For instance, if your sql statement is

      select a.* , b.* from a_table a, b_table b where a.column_name = b.column_name

      I'd like to have an auto complete in the where clause when I type in the table alias. a. or b. for the table.

      I think this would be very helpful, especially for large sql statements.

      Thanks!

    • September 8, 2007 at 8:58 am #24922
      peterlaursen
      Participant

      You are right that support for alias in autocomplete is missing. When columns and other object have 'weird' names (what is often the case with big 'live' databases) it would be very nice. You are not the first one pointing to that.

      However we will then need to parse the content of the editor (in real time) to identify the alias names used in the context and probably store in a (MEMORY type would work) sqlite database.

      Optimally we should only autocomplete aliases for each individual statement. So it raises some architectural issues that are not very simple!

      We have allready recorded this in our TODO, but not scheduled it yet.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.