ADELIA |
|
|
|
|
(I) |
|
|
|
|
Section for use
INITIALIZATION
Syntax
SQL_SFL n SeriesVarId
SeriesVarId |
→ |
SeriesVarId VarId | VarId |
Description
This is a loading instruction performed by a static SQL query.
This instruction marks the beginning of the static SQL query block which will be used to load the subfile, indicated by its number n.
The SQL_SFL instruction must be followed by query instructions which begin with the character "+", and terminate with the E_SQL_SFL instruction.
n is the subfile number defined in the layout. Example: 1 for the subfile *1.
SeriesVarId are the variables which will receive the values obtained in the query; they often belong to the subfile.
They must be in the exact sequence as those variables obtained in the SQL query.
Only one SQL_SFL (or SQL_SFL_D) instruction can be used per subfile.
See also the topic Integrating SQL into ADELIA Programs.
Example
SQL_SFL 1 Z_CUSTOMER_CODE Z_CUSTOMER_NAME |
: subfile *1 description and |
|
: loading variables |
+ SELECT CCUSCO, CCUSNA |
: from CUSTOMER file |
+ FROM CUSTOMER |
: where CPAYCO = :Z_PAYMENT_CODE |
+ WHERE CPAYCO = :Z_PAYMENT_CODE |
: |
E_SQL_SFL |
: End of static SQL query |
|
: block to load the subfile. |
CLEAR 1 |
: Adelia automatically |
MANAGE_SFL 1 |
: reads the cursor |
UPD_SFL |
: resulting from the SQL |
END_MANAGE_SFL |
: execution, to load the |
|
: subfile. |
See also the list of 4GL instructions by topic