After definining the columns and running the query with two joined tables, receive the error as given below for Toad for Data Analysts:
**********************************************************************
Exception Information
**********************************************************************
Exception: System.NullReferenceException
Message : Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.Gui.MainForm.FindOpenedToolWin(Type type)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.get_ActivePalette()
at Quest.Toad.QueryBuilder.QueryBuilderControl.get_SelectedDatabase()
at Quest.Toad.QueryBuilder.QueryBuilder.get_SelectedDatabase()
at Quest.Toad.ExplainPlan.ExplainPlanControl.GetSQLText()
at Quest.Toad.ExplainPlan.ExplainPlanControl.DoExplain(Object document)
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Data Analysts.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center