Click above to get retro games delivered to your door ever month!

   By pressing Space Bar a Definition Frame is opened allowing you to
   modify or to add properties to a key field.

   By pressing the Options button on the frame, the expression that makes
   up the single key field can modified. The Alt-1 keys allow for rapidly
   importing previously defined functions, variables or field expressions.

   The key field's expression can make use of special markers, which will be
   substituted by the system with the correct value when computing the
   indexkey expression. The markers available are:

     . %N - substitute with the field name

     . %L - substitute with the field length

     . %D - substitute with the number of decimals

Example:1

   If the index is built on the fields Field1+Field2, by entering
   LOWER(%N) into Field1's index expression, the final index will be
   LOWER(Field1)+Field2. The %N character, in this case, represents the
   name of the field.
    If in the global index expression (see) "UPPER(%)" is entered, the final
   result will be UPPER(LOWER(Field1)+Field2).

Example:2

   UPPER(%N)

   A key field ArtCod, character, becomes UPPER(ArtCod).

Example:3

   STR( %N, %L, %D )

   A key field OrdNum, numerical with length 6 and 3 decimals, the expression
   becomes STR( OrdNum, 6, 3 ).