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

Wish: columns in column picker in original order

UlrichUlrich Posts: 10
edited January 25, 2007 10:10AM in SQL Prompt Previous Versions
Hi,

I'd like to have an option to switch off the alpha sort for the columns in the column picker window.
For me, it works much better to find a column in the order in which they are defined in the table.

Cross-database support would be very much appreciated as well

Thanks
Ulrich

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Thanks for the suggestions Ulrich, we'll keep them in mind for a future release. I think the cross-database support will appear very soon based on the number of requests we're getting for it.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    I agree with Ulrich. This was an option in Version 2 and to me is a much desired freature. The list in the joins suggestions would work much better too. I have a standared that all table contain a created and modified date columns, and I'm being presented with the following:

    .[Created_By] = [c].[Created_By]
    .[Created_Dt] = [c].[Created_Dt]
    .[Modified_By] = [c].[Modified_By]
    .[Modified_Dt] = [c].[Modified_Dt]
    .[Ticket_Id] = [c].[Ticket_Id]

    Where Ticket_Id is the only PK/FK relationship. I know I can turn off matching column names but if the PK was first, this would not be necesary.

    Dave
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    Thanks for posting.We might well add an option for grouping of JOIN conditions by their type in a future release.


    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.