Need some help on QTableview Sorting : SQLTableModel + Qtableview + Sorting Varchar as number
-
Hello,
Thanks for taking time to read my post. I have a MySQL table with memberid as varchar column. I need to sort it as an integer (Eg. 1, 2, 3 etc) instead of (1, 10, 11... 2). I have read that MySQL has a ORDER BY CLAUSE. (My data is a collection of alphabet and numbers eg AF1, AF10, AF11..AF19, AF2)I have also enabled in QTableview : set sorting enabled to true.
The Question is : How can i enable sorting when the Headerview is clicked to enable the sorting using the ORDER BY CLAUSE.
Please help.