Problem
Manually entering a value > 4 in SQL > SQL Lists > # Vals on Line 1 results in
.NET exception: System.NotSupportedException: Profile.saveGui2ProfileFile: ...
Environment
Steps to Reproduce
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.
thanks for your detailed feedback. I really appreciate it.
The drop-down boxes should not allow manual input. Only the values in the drop-down boxes are allowed
I will change this design error
And I will check if I can increase the max value from 4 to 8
Regards
Guido
Thank you!
Issue is now fixed with the new Release
It works great and I really like how you extended it for the larger values of 20, 100, and 999. Thanks again,
-Kick