Products Downloads


French version


 

 

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

 

↑ Top of page


  • Aucune étiquette