Previous Topic

Next Topic

ApplyOrder - Memory Table Method

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

See Also

Form Designer Table Methods

Book Contents

Book Index