search

jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
153 stars 28 forks source link

Crash when sorting on some columns #1

Closed jokedst closed 6 years ago

jokedst commented 7 years ago

Had ran this query: select sum(belopp), substr(transdatum,1,5) from this group by substr(transdatum,1,5) order by 2

Tried to sort by second column by clicking on header Got this exception:

** Exception Text ** System.ArgumentException: [substr(transdatum isn't a valid Sort string entry. at System.Data.DataTable.ParseSortString(String sortString) at System.Data.DataView.CheckSort(String sort) at System.Data.DataView.set_Sort(String value) at System.Data.DataView.System.ComponentModel.IBindingList.ApplySort(PropertyDescriptor property, ListSortDirection direction) at System.Windows.Forms.DataGridView.DataGridViewDataConnection.Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction) at System.Windows.Forms.DataGridView.SortInternal(IComparer comparer, DataGridViewColumn dataGridViewColumn, ListSortDirection direction) at System.Windows.Forms.DataGridView.Sort(DataGridViewColumn dataGridViewColumn, ListSortDirection direction) at System.Windows.Forms.DataGridView.OnColumnHeaderMouseClick(DataGridViewCellMouseEventArgs e) at System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.DataGridView.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

** Loaded Assemblies ** CsvQuery Assembly Version: 0.1.5782.17473 Win32 Version: 0.1.5782.17473 CodeBase: file:///C:/Program%20Files%20(x86)/Notepad++/plugins/CsvQuery.dll