SqlDbx
You are not logged in.
Lets support i want to search through a table 'table_name'
as soon I write "select table_name." it shows a popup with table column names "in some random order". This ordering is different from dictionary order in previous releases. I am facing this problem with version 3.29 as well as 3.30, however with 3.26 there is no such issues and table fields are shown in dictionary order.
BTW, from where I can download the oder version, so that I can check when this problem actually started
Offline
Table columns in popup are not in random order.
They are in the same order as in create table statement.
The rationale behind it that usually important table
columns are in the beginning and when you create
tables you do not add fields in alphabetical order.
Offline
Agree with sqldbxhelp, that important table columns are created first. Ordering while creating table is important, but while extracting data, user need some particular columns and that may not be dependent on create order.
With current implementation, he needs to go through all the column names to look for his columns of interest & if there are large number of columns (163 in my case) he can overlook a few.
Well is there any hack to get the columns in dictionary order.
Offline
I am not sure why you say "he needs to go through all the columns".
Just start typing and the column will be selected.
There's no any hack to get the columns in sorted order.
The thing we can consider is to make it as an option.
Offline