Programming with Reflection

image\rwnprg32.gif AppendSQLStatement method

 

Syntax object.AppendSQLStatement Type, Statement

 

Description

Adds to the current SQL statement. The addition is made to the portion of the query specified by the Type argument. Use SetSQLStatement to set the initial query. You can use repeated AppendSQLStatement methods to create query strings of any length. This method applies to AS/400 data transfer only, and is only relevant during 5250 sessions.

Arguments

Type Argument type: Enumeration
Specifies an SQL query type. Possible values are :

 rcAS400Select
rcAS400Where
rcAS400OrderBy
rcAS400Having
rcAS400GroupBy
rcAS400JoinBy

 See SetSQLStatement for additional information about these values.

Statement Argument type: String
The string to append to the specified search condition. See SetSQLStatement for information about the correct syntax for each query type. The maximum string length is 128 characters. You can use additional AppendSQLStatement methods to add additional length.

 

image\jump.gif Example

image\jump.gif Keyword Index

image\popup.gif Related Topics

image\popup.gif Reflection products that use this command