Autoformat writes Table Name infront of each field.

Boris Rath

11 years ago
updated 8 years ago
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 ...

Replies 4

Oldest first
Newest first Oldest first

Anonymous

11 years ago

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

Reply Link

Boris Rath

11 years ago

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.

Reply Link

Boris Rath

11 years ago

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.

Reply Link

Anonymous

11 years ago

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.

Reply Link