Sort (Sort Advanced)

Applicability:

• Cadcorp SIS Map Modeller
• Cadcorp SIS Map Editor
• Cadcorp SIS Map Manager
• Cadcorp SIS Map Express
• Cadcorp SIS ActiveX Modeller
• Cadcorp SIS ActiveX Manager
• Cadcorp SIS ActiveX Viewer

Ribbon Group:

Table-Sort & Filter

Associated commands:

• Sort Ascending
• Sort Descending
• Query Builder
• Find
• Reset Filter
• Select All
• Deselect All
• Toggle Selection

Description:

 Sort sorts the rows in a Table Window based on the values in one or two columns. The sorting works alphabetically for string values, and numerically for integer or floating point values.

Note: When using the Expression Builder numbers as strings that are cast to integer or absolute (decimal, float) values are not always treated as numeric. To ensure they are treated as numeric (especially when sorting) you should use the following casting methods:

Integers as strings - you can use Int(Val("123"))

Floats as strings - you can use Abs(Val("3.1415"))

Top of page AComTableSort

Send comments on this topic.

Click to return to www.cadcorp.com

© Copyright 2000-2017 Computer Aided Development Corporation Limited (Cadcorp).