WinStudio

LoadInReverse Property

Applies To

IWSIDOCollection interface

Definition

Determines whether the collection will be loaded in first-to-last order (False) or last-to-first order (True). The default is False.

Get Syntax

object.LoadInReverse

Part	Description
object	Required. A reference to an IDO collection object.

Set Syntax

object.LoadInReverse = Boolean

Part	Description
object	Required. A reference to an IDO collection object.
Boolean	Required. A Boolean value indicating whether the collection will be retrieved in ascending (True) or descending (False) order.

Remarks

With the default behavior (this property set to False), using the initial Refresh action or exiting Filter-In-Place gets the top n rows, and the GetMoreRows method retrieves batches of n rows in descending order, appending them to the collection. If this property is set to True, the initial Refresh gets the last n rows, and the GetMoreRows method retrieves batches of n rows in ascending order, prepending them to the collection.

NOTE: When changing this setting, do not immediately call GetMoreRows. A call to Refresh or to leave Filter-In-Place should follow.

Example

Sub Main()
   ' Loads the primary collection backwards
   If Not ThisForm.PrimaryIDOCollection.LoadInReverse Then
      ThisForm.PrimaryIDOCollection.LoadInReverse = True
      ThisForm.PrimaryIDOCollection.Refresh()
   End If
End Sub