Toad World® Forums

System.NullReferenceException

While trying to join tables, the error message below pops up as soon as I press ‘.’ after the table abbreviation. Any idea on that?

For example, select * from employee e where e. --> and the error pops up. I can continue by pressing close.

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Sybase.Data.AseClient1.AseConnection.Close(Boolean disposing)
at Sybase.Data.AseClient1.AseConnection.CloseWithoutReturningToPool()
at Sybase.Data.AseClient.AseConnection.CloseWithoutReturningToPool()
at Sybase.Data.AseClient1.AseCommand.CheckResult(Int32 res)
at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
at Sybase.Data.AseClient1.AseCommand.ExecuteReader(CommandBehavior commandBehavior)
at Sybase.Data.AseClient.AseCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Quest.Toad.Db.ProxyCommand.ExecuteReader(CommandBehavior behavior)
at Quest.Toad.Db.Connection.Query(CommandBehavior behavior, String sql, Object[] parameter)
at Quest.Toad.Db.Connection.Quest.Toad.Db.IConnection.Query(String sql, Object[] parameter)
at Quest.Toad.SAP.SybaseLanguageDialect.GetDefaultOwner(IConnection connection, String database)
at Quest.Toad.CodeInsight.LanguageDialect.DefaultOwner(IConnection connection, String schema)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List1 ownerList, Int32 pad, IInsightLookupRequest request) at Quest.Toad.CodeInsight.LanguageDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List1 ownerList, Int32 pad, IInsightLookupRequest request)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsightThread(Object obj)

disconnecting and reconnecting seems to have fixed the issue this time - in case someone is having same issue.