Programming with Reflection

$image\rwnprg32.gif$ Xfr400SelectString property

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

Description

Returns (first syntax line) or specifies (second syntax line) which fields to transfer. 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. If you don't enter any field names, all fields in the file are transferred. Use this syntax to list particular fields:

For example:

Session.Xfr400SelectString = "LAST, FIRST, ID, PHONE"

To perform functions on the contents of a field, use this syntax:

<function>(<field name>)

For example:

Session.Xfr400SelectString = "AVG(PAY)"

The available functions are AVG, COUNT, MAX, MIN, and SUM.

$image\jump.gif$ Keyword Index

$image\popup.gif$ Related Topics

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