Problem
Manually entering a value > 4 in SQL > SQL Lists > # Vals on Line 1 results in
.NET exception: System.NotSupportedException: Profile.saveGui2ProfileFile: ...
Environment
- NPP++ Version: 8.4.65 (64-bit)
- SQLinForm Gui: 6.24.4.1
- Engine Release: 6.24.03.22
- Priority: Low
Steps to Reproduce
- Navigate to Plugins > SQLinForm > How Formatting Options
- In SQLinForm tab, click SQL > SQL Lists
- In SQL lists panel, manually type 8 for # Vals on Line 1 and # Vals on Line > 1
- Click Profile > Save Profile
- Note the generated Exception
Use case
It is not uncommon to receive algorithmically generated SQL with IN lists of hundreds (and sometimes even thousands) of values. Having a larger number of aligned values per line can greatly enhance readability.
ScreenShot
Exception Text
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. *********** Exception Text ******** System.NotSupportedException: Profile.saveGui2ProfileFile: System.NullReferenceException: Object reference not set to an instance of an object. at SQLinFormNpp.Profile.gui2TableOptionValue(Option opt, Control control) at SQLinFormNpp.Profile.gui2TableOptionValues() at SQLinFormNpp.Profile.saveProfile(ProfileType pt) at SQLinFormNpp.Profile.saveProfile(ProfileType pt) at SQLinFormNpp.frmMyDlg.saveToolStripMenuItem_Click(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ******** Loaded Assemblies ******** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.8.9232.0 built by: NET481REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll ---------------------------------------- SQLinFormNpp Assembly Version: 6.24.4.1 Win32 Version: 6.24.04.01 CodeBase: file:///C:/Program%20Files/Notepad++/plugins/SQLinFormNpp64/SQLinFormNpp64.dll ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.8.9181.0 built by: NET481REL1LAST_C CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.8.9236.0 built by: NET481REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.8.9037.0 built by: NET481REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.8.9037.0 built by: NET481REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.8.9236.0 built by: NET481REL1LAST_B CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.8.9037.0 built by: NET481REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- Accessibility Assembly Version: 4.0.0.0 Win32 Version: 4.8.9037.0 built by: NET481REL1 CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- ******** JIT Debugging *********** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
