Columns (1 based) to be sorted initially upon entry.

Product Version

Property Value

Obj.dbInitSortCols = "ColIndex, ColIndex-, ColName, ColName DESC"

QuickProp Keyword Abbreviation

Remarks

• FieldName decend order must be 'Fields DESC'(Employeeid DESC). FieldOrdinal decend order must be 'number-'(2-).
• Rememebr that 'Cols' ordinals is 1 based and ORDER BY field ordinals is 0 based. Fieldname is absolute and not affectd by any numbers.
• Avoid using ORDERby in dbSQL when using dbInitSortCols
• If all fieldnames are used, then dbInitSortCols and dbInitSortFlds has no difference.

Example

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim CS As New Tornado.z
  With CS
    .dbQP = "U=12| S=17|Gdf=0,1,2,3,4| D=Nwind| Q=Orders| Th=tit=Multi-Columns Sort with Automatic Lineup"
    .dbSortFlds = "0,1,employeeid,3"
    .dbSortColLeftJustify = True
    .dbInitSortCols = "employeeid DESC,1"
    .ASPdbNET()
  End With
End Sub
</script>

See Also

z Class | Tornado Namespace | dbInitSortFlds | dbSortFlds | dbColSortSQL | dbSortColLeftJustify

---