When loading a Query Builder (.tsm) file which was created in Toad for MySQL 4.1 the following error occurs and although the Query Diagram loads, the actual query doesn't and, therefore, can't be run. This is only happening with one particular file. Other MySQL .tsm files load OK.
Exception: System.Exception
Message : Error occurs
Stack Trace:
at DevExpress.XtraGrid.GridControl.EndUpdate(Boolean synchronized)
at DevExpress.XtraGrid.GridControl.EndUpdate()
at Quest.Toad.QueryBuilder.QueryBuilderControl.SetXml(String xml)
at Quest.Toad.QueryBuilder.QueryBuilderControl.set_Xml(String value)
at Quest.Toad.QueryBuilder.QueryBuilder.OpenFile(String file)
at Quest.Toad.QueryBuilder.QueryBuilder.timerDelayFileLoad_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Inner Exception: System.NullReferenceException
Message : Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.QueryBuilder.WhereClauseClass.GetWhereClause(Boolean forDisplay)
at Quest.Toad.QueryBuilder.SqlBuilder.GenerateSqlStatement(ColumnCriteriaCollection columnCriteria, DiagramControl diagramControl, Boolean distinct, Int32 topRowcount, Boolean topPercent, Boolean heterogeneousQuery, Boolean& groupByOrAggregateComplete, QueryBuilderControl model)
at Quest.Toad.QueryBuilder.QueryBuilderControl.GenerateSqlStatement()
at Quest.Toad.QueryBuilder.QueryBuilderControl.gridViewCriteria_Layout(Object sender, EventArgs e)
at DevExpress.XtraGrid.Views.Base.BaseView.RaiseLayout()
at DevExpress.XtraGrid.Views.Base.BaseView.LayoutChanged()
at DevExpress.XtraGrid.Views.Grid.GridView.LayoutChanged()
at De