Scans records of an external file using a given index.
Xfor each <file_name> [Index <index_name>]
View Syntax conventions
Is the name of the Data View defined to access the external file.
Defines the name of the index to be used.
Is the name of the Data View Index.
Clause that can be specified to establish a condition for data retrieval.
Any valid logical expression.
Only returns records where the set of values of the attributes referred to is unique.
Specifies the code to be executed when the Xfor each does not filter any record.
Objects: Procedure, Web Panel
This command defines an iterative loop for an external file, using the specified index (if any) and filters data according to the Conditions declared in the Where statements.
When a Data View object without an associated table is defined, this command will obtain the required information to perform updates over an external file. If the Data View has an associated table, the For Each command may be used instead of the Xfor Each command.
GeneXus will try to optimize the search in an intelligent way, taking into account the index specified in the Xfor Each statement and the conditions defined in the Where of the Xfor Each group. Xfor Each groups can be combined by nesting them or by defining them as parallel groups.
The differences between the For Each and the Xfor Each commands are:
|Several tables may be associated with the Group.
||Only one table can be referenced.
|The base table is inferred by GeneXus.
||The base table must be declared by the user.
|The index is inferred by GeneXus according to the specified order.
||The index must be declared by the user.
|Relationships between nested For Each groups are done by GeneXus
||No relationship is detected between nested Xfor each groups.
For Each command
Xfor First Command
Data View object