When I tried to open my SQL file I received this error. Toad for SQL Server will not open it.
There is not anything unusual with the code but Toad for SQL Server 4.5 does not like it.
I do not have issue with this file in Toad for SQL Server 4.
System.AccessViolationException
Invalid pointer
Stack Trace:
at QP5Proc16(Int32 , Void* , Int32 , Int32 )
at Quest.QP5.Chunk.get_PieceCount()
at Quest.Toad.Editor.Parsers.SqlParser.Parse(String text, Boolean checkSyntax)
at Quest.Toad.Editor.EditorForm.Parse(Boolean processParserMessages, Boolean syntaxCheck)
at Quest.Toad.Editor.EditorForm.Parse()
at Quest.Toad.Editor.EditorForm.DoFileOpen(String file)
at Quest.Toad.Gui.MainForm.OpenFile(String file, PredefinedParameterCollection predefinedParameters)
at Quest.Toad.Gui.MainForm.openFileButton_ItemClick(Object sender, ItemClickEventArgs e)
at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.OnShortcutItemClick(BarItem item, BarShortcut shortcut)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.CheckShortcut(BarManager manager, KeyEventArgs e)
at DevExpress.XtraBars.MessageFilter.BarManagerHook.PreFilterMessage(Message& m)
at DevExpress.XtraBars.MessageFilter.BarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message& m)
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
A sample file is attached to solution.
