Directly modifies a scalar or array variable in the database.
FLAG expression variable
| Option | Description |
|---|---|
| expression | The source value. |
| variable | The persistent variable to modify. |
Retrieves database records, and iterates over the resulting record set or subset thereof.
FOREACH variable IN <iterator> [ FROM | BACK | EVERY ] [ POLYMORPHIC ] [ SERIAL ] [ SECURE | KEYONLY ] [ MULTI expression ] [ GS status ] <iterator> := <object> | <profile> | extract_file | array | <list attribute> <object> := object_name( argument [ ,...n ] ) <profile> := object_name.profile_name( argument [ ,...n ] )
| Option | Description |
|---|---|
| variable | The instance variable into which each record is loaded. |
| iterator | The set or array to read. This can be a profile, persistent class, extract file or Array. If a persistent class is specified, records are read using the class's default profile. |
| ,..n | The key values to read. |
| FROM | Reads records in profile order, starting from the specified key values. Note: When an action qualifier is not specified for the ForEach command, From is used as the default action qualifier.
|
| BACK | Reads records in reverse profile order, starting back from the specified key values. |
| EVERY | Reads records that match the specified key values. |
| POLYMORPHIC | Has an effect in a persistent inheritance hierarchy. If specified, records are returned which are of the same type or class as the first qualifier or any of its sub-classes. |
| SERIAL | Increases efficiency by retaining pointers. |
| SECURE | Facilitates record locking of the database in an applications that do not force integrity. |
| KEYONLY | This command option is not supported on applications deployed to Windows. |
| MULTI expression | This command option is not supported on applications deployed to Windows. |
| GS status | Indicates if there are no records retrieved, using the specified qualifier. |