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

Bug Displaying Fields When Table Name Is Typed Out and Paren

I have noticed in Query Analyzer that when I type
"Select * from ePe" then select the table name from the list, when I get to the "Where " it pops up a list of fields from that table, as expected.
However, if I type out the name of the table, as in:
"Select * from ePerson" and get to the "Where ", the list that pops up is a list of functions, aggregate and other. This appears to be due to the capitalization of the table name. In the list it is "EPerson", but when I type it as "ePerson" I get the function list. My database sort order is NOT case specific. I am using the default Collation for SQL 2000.
I have tested this over and over, and it always happens the same.

I have also noticed that when attempted to use parenthesis in a Where clause, SQL Prompt just gives up and no longer displays a field list. Because of this, if I want to use SQL Prompt I must construct my Where clause with no parens and insert them later.

Thanks,
Chris
stamey
0

Comments

1 comment

Sort by
  • Tilman
    Hi Chris,

    thanks for reporting these issues. We are aware of the case issue and will fix it in SQL Prompt 3. It is also on our list to improve the automatic pop-up behaviour of the candidate list, so hopefully that will deal with the problem of the parenthesis. Having said that, I can still get the candidate list to pop up using Ctrl + Space after I've used parenthesis.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.