[SQL Script] - Ordination in the view of the alias

[Anderson Oliveir]

Good morning everyone!!!
I downloaded the new version 12.0.7.1837 for an evaluation, but I noticed an problem with me that was not happening in the previous version release ...

When using "SQL Script" after creating an alias for a table, for example:
select p.
from people p

After entering "p." in select, the browser opens a frame with the columns of the table (people), but now, it is showing the columns in alphabetical order and not in the original order as it was created !!!
I believe it may be some configuration parameter, but I did not find out where it is !!!

Can anybody help me?

 

[Marcel Hoefs]

I think this is due to the sorting option in the column list that is shown after entering "p." If you look in the bottom left corner of the list you will see an arrow pint downward. Pressing this widget toggles the sorting of the column list.

Regards, Marcel.

 

[William Robertson]

Never noticed that before. Thanks!

 

[Anderson Oliveir]

Thanks for listening!

Follow my problem:

When I write, "select and". From the Employer ", my list in the SQL window shows me:
1-----------------
description_address
id_employer
name
number address
social security

But the correct one that should show me:
2-----------------
id_employer
name
social security
description_address
number address

* I create the table as listed above (2).

Att
Anderson Oliveira

 

[Anderson Oliveir]

Perfect my friend!!!
Thanks fully

Att
Anderson Oliveira