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

evaluation version 3.5.0.333 and [] object

ugoredaugoreda Posts: 3
edited August 8, 2007 7:40AM in SQL Prompt Previous Versions
I was in the process of testing the evaluation version of sql prompt 3.5.0.333

if you type:

SELECT
o.[name]
FROM
[sys].[sysobjects] o
-- nothing here
INNER JOIN [sys].[sycolumns] c
ON (
o.[id] = c.[id]
)

and then start writing:

SELECT
o.[name]
FROM
[sys].[sysobjects] o
-- add this line (typing, not copy and paste)
INNER JOIN []
-- ....
INNER JOIN [sys].[sycolumns] c
ON (
o.[id] = c.[id]
)

I get the error:
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Engine.AbstractCandidate.CompareTo(ICandidate other)

issue is that when I enter [, autocompletes enters [] and [] is not an identified objects, hence the crash...


it is VERY annoying,
is this issue in the process of correction?

Comments

Sign In or Register to comment.