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

[Bug?] Select * from Store as s <return>

paschottpaschott Posts: 71 Bronze 4
edited September 15, 2009 6:44AM in SQL Prompt Previous Versions
Not sure how to categorize this. I don't think this is an option that I've missed, but this didn't happen in 3.x. When I type something like:

SELECT * FROM St -- and then autocomplete so it becomes:
Select * from Store as s

If I then hit ENTER to start a new line, the "as s" changes to "as SELECT" which I often don't catch right away. It works as expected if I hit a space after the "as s", but not if I hit ENTER.

Am I missing a setting here or should this be filed as a bug? I can consistently reproduce this on any table name that starts with an S, U, D, or I - each one of those will change to "SELECT", "UPDATE", "DELETE", or "INSERT" if I hit ENTER after the alias.

--Quick note - this seems to happen even when I take "ENTER" off of the keys that will auto-complete. I don't think I had that option turned off before, though.


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    I was not able to replicate the issue.

    Can you kindly email us your SQL Prompt settings at support@red-gate.com and I will generate a call reference for you and we can proceed from there?

    Kindly let me know your view on this.

    Note: Please include this forum link in your email.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.