Field help (ALQTEXTE) @ L.V. Expertise X3

The request itself is then entered in the classic SQL form comprehensible by the database.

Several notes on the subject of this request :

Any Select request including complex ones can be written here, provided it return a field number less than the maximum admissible.
it should be remembered that the NOMCHAMP(index) field, managed in the NOMTABLE table, is defined in the database like the NOMCHAMP_indice field in the NOMTABLE tables, index value 0, 1, 2... N-1, N being the dimension of the field.

For example, it is possible to write :
Select LOGIN_0, CHEF_2 From AUTILIS
Where USR_0 like %1%
Order by CREDAT_0

In a request of this type, it is possible to define the parameters using the syntax %N%, which refers to parameter number N defines in the parameters grid (%1% in the example above). These parameters will be entered by means of thebutton during the execution of the request.