QrySelect contains the selection expression used to determine which records are to be made available for processing.

dbfile.QrySelect Type (*String)

Remarks

QrySelect must be set prior to opening the file (see OPEN command).

If QrySelect is not set, the value of the QrySelect parameter specified in the DCLDISKFILE command is used.

QryKeyFlds is used in conjunction with QrySelect to specify ordering of the selected records.  Use QryFileName to specify the name of the temporary query file created.

When using QrySelect, please Note:

• *NONE (default) - there is no selection expression available for processing.
• Selection expressions are evaluated during file open time.  Therefore, a run-time error will be generated during the opening of the file when a selection expression error is encountered.
• The Select statement syntax can vary depending upon the syntax supported by the target database engine.  Each key field is composed of a field name followed by optional attributes that determine the sorting order (ascending, descending, or absolute value for numeric fields).

Requirements

Namespace: ASNA.VisualRPG.Runtime

Assembly: ASNA Visual RPG Runtime (in ASNA.VisualRPG.Runtime.dll)

Platforms: Windows 2000 Professional SP4, Windows 2000 Server SP4, Windows Server 2003, Windows XP Professional SP2, Windows Vista Business Edition 

See Also

ASNA.VisualRPG.Runtime
DBFile Class
DBFile Members
DCLDISKFILE
QryFileName Field
QryKeyFlds Field