User settings

Types of parameters

  • FADAcore parameter: common to all FADA applications.
  • Application parameter: specific to a FADA application (often in color).

FADAcore does not recognize application parameters, which are therefore not described here.

FADAcore parameters

imgtab1 and texttab1

Image and text for the Info tab.
If imgtab1 is empty, the application's image is loaded instead.
If texttab1 is empty, the application's description text is loaded instead.

Db_lang : Language of the data

To support accented characters —which vary by language— in sorting and filtering.

Languages supported by FADAcore:

  • English (EN): no accents, no diacritics.
  • Esperanto (EO): with non-diacritical accents (ĉ, ĝ, ĥ, ĵ, ŝ, ŭ).
  • Spanish (ES): with non-diacritical accents (ñ) and diacritical accents (á, é, í, ó, ú, ü).
  • French (FR): with diacritical accents (à, â, ä, é, è...).
Impact on sorting

Letters with diacritical accents are equivalent to their unaccented counterparts.
Letters with non-diacritical accents are distinct characters in their own right.
Sorting examples:
valise, vélo, veste, vêtement (diacritical accented letters).
sano, suno, ŝano, ŝido (non-diacritical accented letters).
cano, caña, caño, cañón (non-diacritical accented letters).

In any case, sorting is not case-sensitive.
Sorting example: mal, Mâle, maux, Mot, mots.

Impact on user filters

With accent-free languages, the data is either unfiltered or filtered (2 states).

2 states : unfiltered
Unfiltered

2 states : filtered
filtered
Decription LIKE '%Test%'

For languages with accents, the data is either unfiltered, strictly filtered, or filtered without taking accents into account (3 states).

3 states : unfiltered
Unfiltered

3 states : filtered without accent
Filtered without accents
Decription LIKE '%d_nn__%'-> donnée, donne, donna

3 states : strictly filtered
Strictly filtered
Decription LIKE '%donnée%'-> donnée

Strictly filtered: accented letters must match.
Example:
Contains ‘ñ’ returns caña, caño, and cañón.
Contains ‘n’ returns cano.

Filtered without considering accents
Example:
Contains ‘ñ’ returns cano, caña, caño, and cañón.
Contains ‘n’ returns cano

Script_modify_data : data modification

Allows the use of INSERT, UPDATE, and DELETE statements in user scripts.
If an error occurs while the script is running, a ROLLBACK is performed at the end.

Script_modify_schema : db schema modification

Allows the use of CREATE, ALTER, and DROP statements in user scripts.
If an error occurs while the script is running, a ROLLBACK is performed at the end.