[Solved] .NET exception: System.NotSupportedException: Profile.saveGui2ProfileFile: ... when setting SQL > SQL Lists > # Vals on Line 1

5 Posts
2 Users
0 Reactions
233 Views
 kick
(@kick)
Member
Joined: 3 years ago
Posts: 11
Topic starter  

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

  1. Navigate to Plugins > SQLinForm > How Formatting Options
  2. In SQLinForm tab, click SQL > SQL Lists
  3. In SQL lists panel, manually type 8 for # Vals on Line 1 and # Vals on Line > 1
  4. Click Profile > Save Profile
  5. 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

image

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.


   
Quote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 216
 

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


   
ReplyQuote
 kick
(@kick)
Member
Joined: 3 years ago
Posts: 11
Topic starter  

Thank you!


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 216
 

Issue is now fixed with the new Release

grafik

 


   
ReplyQuote
 kick
(@kick)
Member
Joined: 3 years ago
Posts: 11
Topic starter  

It works great and I really like how you extended it for the larger values of 20, 100, and 999. Thanks again,

-Kick


   
ReplyQuote
Share: