Programming with Reflection

image\rwnprg32.gif Xfr400WhereString property

 

Syntax

object.Xfr400WhereString
object.Xfr400WhereString = Value

Data type

String

 

Description

Returns (first syntax line) or specifies (second syntax line) one or more conditions that determine whether a record is transferred. 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 name> <test> <value>

For example:

Session.Xfr400WhereString = "PAY > 11"

The available tests are  =, <, >, <=, >=, <>, NOT, LIKE, IN, BETWEEN, IS, ISNOT, and SUBSTR.

 

image\jump.gif Keyword Index

image\popup.gif Related Topics

image\popup.gif Reflection products that use this property