SqlDbx Forum

SqlDbx

You are not logged in.

#1 2009-04-28 09:00:24

yogi_raj_143
Member

Problem in autocomplete while writing SQL query

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

#2 2009-04-28 09:53:54

sqldbxhelp
Administrator

Re: Problem in autocomplete while writing SQL query

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

#3 2009-04-29 00:11:25

yogi_raj_143
Member

Re: Problem in autocomplete while writing SQL query

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

#4 2009-04-29 09:36:08

sqldbxhelp
Administrator

Re: Problem in autocomplete while writing SQL query

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

Board footer

Powered by FluxBB