Autoformat writes Table Name infront of each field.

Planned

Comments

4 comments

  • Sorry, but it's the limitation of the query building engine that can not be fixed fast. You can add alias for table, so you will have a shorter SQL:
    Select t.Field1 From Table t
    0
    Comment actions Permalink
  • Avatar
    Boris Rath
    Yes in case of an alias it is necessary to put the alias infront of the Field, because there could be a table 2 times with same fieldnames.

    But when there is no Alias i cant see the benefit of qualifying the Field names.
    0
    Comment actions Permalink
  • Avatar
    Boris Rath
    ofcourse this is because our Fieldnames contains the Table name... and are mostly unique...

    It would just be nice to have an Option to turn it on and off.


    0
    Comment actions Permalink
  • Thank you for sharing your thoughts with us. Unfortunately this behavior can not be changed quickly. We already had a number of requests to change it, so we already added this in our to-do list.
    0
    Comment actions Permalink

Please sign in to leave a comment.