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:

<field> <sequence>

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