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

Surround with bracket[] not opening candidate list

zaczac Posts: 8
edited January 25, 2007 6:11AM in SQL Prompt Previous Versions
Can you help me please?

I've downloaded v3 and just tried to use it and come across a problem, or un documented feature.

We use schema in our db that are reserved words ie Order.

So we use the option surround with brackets in sql prompt. When this is active if i type

SELECT * FROM [Order].

The candidate list is not supplied. It works no problems if i turn off the surround with brackets. Is this correct behaviour?




  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Zac,

    Thanks for reporting this, let me set up a test database, take a look into it and get back to you.

    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.