When I started making my database I created several field names that have spaces in the name of the field. Ex: first name
Could this cause any problems? On occasion I have reports that won’t generate properly and I am wondering if this may be a cause.
I am using LO Base 6.3.2 as a front end and MySQL 8.0 as a backend working on W10.
There probably have been examples of this causing problems although I cannot cite one at this time. Most would prefer to use
first_name to define the fields. Use of a space or mixed case will also cause extra effort in SQL and such because the fields need to be surrounded with a backtick in MySQL (other databases may require quotes).
Best to avoid using spaces in naming.
The answer is to avoid using spaces in your field names, aliases, queries, etc, as bugs keep popping up in parts of the Base module, for example as you have found out in “Reports”, where spaces are misinterpreted, the number and frequency of which vary according to LO version over time.