ADELIA |
VADELIA |
|
WADELIA |
MADELIA |
(I) |
(I) (C/S) |
|
(I) (C/S) |
(I) (C/S) |
Warning: In the case of ADELIA programs, this instruction is not compatible with C generator.
Section for use
All
Syntax
BRING_BACK ViewOrEntity TransactionOrWindowOrPage
TransactionOrWindow |
Þ |
TransactionNum | WindowName | PageName | None |
Description
This instruction is used to transfer screen information from the data flow into the corresponding fields in the file or SQL table. This instruction is the opposite of the PRESENT instruction ( Adelia or Visual Adelia and Adelia Web context).
Where a view has the same name as an entity, the view name will take priority.
Note: As this instruction does not make any database accesses, it can be included in either the client or the server part of a program.
Example
* In the VALIDATION section of a program
CHAIN_SQL ITEM *COND(IITEM_COD = :ZIITEM_CODE)
SQL_RET_CODE = *SQLCODE
BRING_BACK ITEM
* The layout field values from the ITEM entity are transferred
* to the file fields
IF SQL_RET_CODE = 0
* If the record exists, it is updated.
UPD_SQL ITEM *ALL *COND(IITEM_COD = :ZIITEM_CODE)
ELSE
* If it does not exist, the record is created in the database.
IF SQL_RET_CODE = 100
CREATE_SQL ITEM
END
END
COMMIT