User preferences in Infotable

[georgeef]

Infotable contains the following fields:

• DATEFORMAT: date format
• CATEG_DELIMITER: category delimiter

These settings affect only the presentation of information in the user interface and not the content, i.e., they represent user preferences. They are better managed as application settings, and not as database settings.

The date format is traditionally managed by the locale settings at system level, since most likely the user wants the same setting across many applications. The category delimiter is specific to MMEX, but again, most likely the user wants the same setting across different database files.

Proposed behavior

Ignore DATEFORMAT and CATEG_DELIMITER in Infotable, i.e., do not read their value and do not offer an interface to update them.

Instead, manage the date format and category delimiter as application settings (@AppStorage).

Compatibility with MMEX Desktop/Android

There is no need for compatibility in application settings. The two fields above are just ignored and they are managed independently of the values in Infotable. Most likely the user would like to transfer them between different platforms as applications settings and not as database settings.

[georgeef]

@guanlisheng
what do you think?

[guanlisheng]

I am fine with leveraging it at the application level. it will also simplify Infotable as well.

@vomikan , @whalley , @renato-mmex , @wolfsolver for awareness.

[georgeef]

CategoryDelimiter has been moved to app settings (Theme) with #241.