Programming with Reflection

$image\rwnprg32.gif$ Xfr400OrderByString property

Syntax	object.Xfr400OrderByString object.Xfr400OrderByString = Value
Data type	String

Description

Returns (first syntax line) or specifies (second syntax line) how to sort selected records. Note: SQL query options can also be set using the SetSQLStatement method. Transfer options set using the method supersede any transfer options entered using this property.

This property affects AS/400 data transfer and is only relevant for 5250 sessions.

Values

The default is "".

This string can be up to 220 characters long and should use the following syntax:

For example, to order the output in descending order based on the value of the PAYRATE field:

Session.XfrOrderByString = "PAYRATE DESC"

$image\jump.gif$ Keyword Index

$image\popup.gif$ Related Topics

$image\popup.gif$ Reflection products that use this property