What are the challenges you face when working across database platforms? Take the survey
Options

Improvements for WHERE clause

EsioNEsioN Posts: 103
edited October 18, 2007 2:42AM in SQL Prompt Previous Versions
Hi,

When typing SELECT commands with a where clause, SP shows me the columns in alphabetical order. It will be nice if I can get the column list in the table physical order, or at least, the primary keys on the top.

Thanks
Ésio

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    OK thanks Esio, that's on our list of possible enhancements for the future.
    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    EsioN wrote:
    Hi,

    When typing SELECT commands with a where clause, SP shows me the columns in alphabetical order. It will be nice if I can get the column list in the table physical order, or at least, the primary keys on the top.

    Thanks
    Ésio

    This would be a very valuable feature. Any idea as to time frame for the build that will include this feature?
    Thanks,
    Beeno
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Beeno,


    I'm afraid not at the moment. Sorry I can't be more help.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    I also agree that this would be a nice (optional) feature. So chalk another vote up to it!
Sign In or Register to comment.