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

Multi-line select statements don't work

When using a multi-line select statement, the column names aren't displayed after the "WHERE".

To reproduce, type "SELECT * " on the first line, type "FROM [dbo].[validtablename] AS a WHERE " and then Ctrl-SPACE. No column names appear. Putting the entire statement on one line and pressing Ctrl-SPACE shows the column names.

Some selections from the candidate list format the statement as multi-line, which makes occurrence of this more likely. An example would be typing "SELECT ", Ctrl-SPACE, select table name, press "."
This puts the "FROM" on the next line.
harriyott
0

Comments

1 comment

Sort by
  • Bart Read
    Thanks for reporting this. That's quite interesting as it's not something we've seen here. Generally SQL Prompt 3 doesn't, or at least shouldn't, get spoofed by newlines or other whitespace, although clearly there are some situations where this does occur. We'll look into it.
    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.