Autoformat writes Table Name infront of each field.

Avatar
  • updated
  • Completed
Is it posible to configure the Autoformat Option so it does not always write the Table name infront of each field when there is no Alias declined on the Table name.

i.e. Select table.field1 from table

in this example the is no need for the table.
it just makes the Code extremly long ...
Avatar
Anonymous
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.
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.


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.
Avatar
Anonymous
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