Topic: Sorting column n1-n2-n3
Sorting column n1-n2-n3
For example:
3-34-1
3-34-2
..........
3-34-10
............
3-36-1
In the settings of TableGrid1 (or button configuration using the "Search"), choose to sort ORDER BY and paste the following condition:
CAST (trim(substr(replace(fieldnumber, '-', ' '), 1, 3)) AS INTEGER), CAST (trim(substr(replace(fieldnumber, '-', ' '), 7, 5)) AS INTEGER), CAST (trim(substr(replace(fieldnumber, '-', ' '), 12)) AS INTEGER)
where fieldnumber - text field type
Download project:
http://myvisualdatabase.com/forum/misc. … download=1