InfoConnect VBA Guide
Attachmate.Reflection.Objects.Emulation.IbmHosts Library / FileTransfer Object / Xfr400SelectString Property
Example
In This Topic
    Xfr400SelectString Property
    In This Topic
    Gets or sets which fields to transfer.
    Syntax
    expression.Xfr400SelectString As String
    where expression is a variable that represents a FileTransfer Object

    Property Value


    If you don't enter any field names, all fields in the file are transferred.

    Remarks

    To list particular fields, use this syntax:

    <field name1>,<field name2>,<field name3>

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

    <function>(<field name>)

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

    This property affects AS/400 data transfer and is only relevant for 5250 sessions. The default is "". This string can be up to 220 characters long.

    Example
    Setting which fields to transfer
    Sub SelectString()
        'This statement lists the LAST, FIRST, ID, and PHONE fields
        ThisIbmTerminal.FileTransfer.Xfr400SelectString = "LAST, FIRST, ID, PHONE"
        
        'This statement specifies the average of the PAY field.
        ThisIbmTerminal.FileTransfer.Xfr400SelectString = "AVG(PAY)"
    End Sub
    See Also