Ask Your Question

Spaces in field names LO Base

asked 2019-10-21 21:15:33 +0100

jodybingo gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-10-21 21:34:23 +0100

Ratslinger gravatar image

updated 2019-10-21 22:07:12 +0100


There probably have been examples of this causing problems although I cannot cite one at this time. Most would prefer to use FirstName or 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.

edit flag offensive delete link more

answered 2019-10-23 10:51:05 +0100

Alex Thurgood gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-21 21:15:33 +0100

Seen: 145 times

Last updated: Oct 23 '19