How can we help you today? How can we help you today?

Ordering in Candidate list

Hi

I have 5 local varibales , not declared in any order , when I type SET I get the 5 variables at the top of the Candidate List but not sorted in anyway , Its not alphabetic and not in the order of declaration .

Is this by design ?

Mike
MikeONeill
0

Comments

3 comments

Sort by
  • tanya
    Hello,

    It actually orders the variables in reverse order i.e. the nearest variables are listed on top of the suggestions as it is generally useful for cases when a DECLARE is followed immediately by a SET statement.

    Is there any other ordering that you would rather prefer?

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • MikeONeill
    HI Tanya

    I suppose its down to individual styles , I normally declare all my variables as a block at the start of an sp , then @(#)Tables etc before I start to set any variables or work on logic . I just find it easier to find variables later . If I were tidier , I suppose I ought to sort these alphabetiacally for prettyness ( alas !!)

    I would have thought the sort order should be local variables on top sorted alphabetically to suit my style best . Maybe as an option to allow other sort styles.

    That said its not a problem as you start to type the @V.. the one you wnat pops to the top anyway , it just looked strange .

    Cheers

    Mike
    MikeONeill
    0
  • tanya
    Hi Mike,

    Fair enough! That said, it is unlikely we will change this behaviour for v4 but I have logged this in our bug tracking system and we will review the sorting order of variables for our future version.

    Thank you for voicing your suggestion :)

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.