method ApplyOrder(Order: Array of Variant)
The ApplyOrder method orders records in a Memory Table in order of the array supplied.
ApplyOrder method syntax has these named arguments:
Parameter |
Description |
|---|---|
Order |
Required. An array of variants, specifying the order for records in the table. |
For example, to reverse the line order for JC Job Estimates:
Dim JCData as Object
JCData = CreateObject("Accredo.JCJobData")
JCData.IndexName = "Job"
count = JCData.Estimate.RecordCount
dim lines[count] as Number
for line = 1 to UBound(lines)
lines[line] = count + 1 - line
next
JCData.Edit
JCData.Estimate.ApplyOrder(lines)
JCData.Save