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

BUG: SQL Promt Intellisense not working on some tables

Intellisense is not working when i select tables named like this:
table_{06B9F041-D2BD-4F9D-B163-21DB03AA1765}
(table_{some guid})

I type select * from then a list of tables appears, i try to choose table
named like table_{06B9F041-D2BD-4F9D-B163-21DB03AA1765} but nothing happens.
Much
0

Comments

3 comments

Sort by
  • Bart Read
    Hi Much,


    Thanks for posting, and sorry for the problems you've been having. Those are perfectly legal table names so it sounds to me like a bug in SQL Prompt. Can you let me know what version of SQL Server you're running with, what editor you're using, and whether you're running in 6.5 or 7.0 compatibility mode please?


    Many thanks,
    Bart Read
    0
  • Much_
    Hi Bart Read!

    I tried this with both SQL Server 2000 SP4 and SQL Server 2005, all the same. I used SQL Query Analyzer and SQL Server Management Studio, the problem occured in both.
    Much_
    0
  • Bart Read
    OK, thanks for that. Looks like it's just a bug in the way we handle the curly braces - I suspect they're being treated as special characters when they shouldn't be as a result of their use as such in snippets. We'll sort this out for version 3.
    Many thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.