ADELIA |
|
|
|
|
(I) |
|
|
|
|
Section for use
INITIALIZATION
Syntax
E_SQL_SFL
Description
This instruction marks the end of a static SQL query block used to load the subfile.
It must follow the "SQL_SFL n" instruction, and the query instructions which begin with the character "+".
Every E_SQL_SFL instruction must correspond to an SQL_SFL instruction.
This instruction is a static loading instruction by SQL query.
Example
SQL_SFL 1 Z_CUSTOMER_CODE Z_CUSTOMER_NAME |
: subfile *1 indication and |
|
: loading of the variables; |
+ SELECT CCUSCO, CCUSNA |
: selection in the CUSTOMER file |
+ FROM CUSTOMER |
: when CPAYCO is equal to the value |
+ WHERE CPAYCO = :Z_PAYMENT_CODE |
: of 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 SQL |
END_MANAGE_SFL |
: execution. |
See also the list of 4GL instructions by topic