Why order of fields in the table tree is in alphabetical order instead of the order in the database?
When dragging the table from the table tree into the Query building area the order is shown as in the database.
Replies 5
Hello,
Possibly the QueryBuilder.DatabaseSchemaTreeOptions.SortingType is set to Name while the expected behavior is observed when this property is set to NameExceptFields.
Please tell me, what version of Active Query Builder you currently use: VCL, WinForms, or WPF, 2.x or 3.0, what is your database server. This information is important.
Thanks so much for the quick response.
We are experiencing this when connecting to Teradata 15 through ODBC. We are using WinForms and version 2.10.0.723. Sorting type is "the default"
QueryBuilder.DatabaseSchemaTreeOptions.SortingType = Name
Hello,
Thank you for your request. This bug is fixed. It will be available in the next build till the end of this week.
Hello,
Please download the new version 2.10.5.773. The bug is fixed there.
I just ran into a situation where the order of fields shown in the query building area is not the order of the fields in the database, why would this happen?