Field help (AVWTEXTE)

Oracle and/or Sql-server requests

If the request operates on a table or view from the current folder, it is preferable to not name this folder in the request, because the views are copied in the daughter folders.

The naming rule for the fields is as follows :

• field_0    (field being the name of the field declared in the dictionary of the table)
• field_n    for a dimensioned field ( n being the index or the dimension starting with 0 )

In the view description, the formulas can figure between "% %". These formulas are evaluated at the time of the validation of the view. In practice the global variables can contain, for example, the name of an external folder (view of an X3 table from another product).

The lines starting with the character "#" are considered as being comments and are not transferred to the database.