WebSite X5Help Center

 
Sinisa B.
Sinisa B.
User

Database viewer - column names (labels)  en

Autor: Sinisa B.
Visitado 10, Seguidores 0, Compartilhado 0  

Hi All,

I am filling the database via a form (OPTION: send to database).
I am using the DATABASE VIEWER object to show the collected data.

Due to the FORM field rules, the database field name cannot contain SPACE (cannot use two or more words as a field name). Thus in the table view of the DATABASE VIEWER, the column name (aka column label) is shown as SINGLE WORD without spaces between words (see below).


I know that in PHPMyAdmin I can change the names of the columns of the database table and thus have two or more words in a column, but then I cannot fill in the data via the form because it will add columns of different names (no space names).

I also know that I can directly enter data using the DATABASE VIEWER and that the above (form) problem could be avoided, but I have to enter data via the form for legal reasons!

So, my question is:
Is there a way to use FORM (send to database option) to fill the database so that in the Database Viewer column names (column labels) could have two or more words separated by a space?
I would like to avoid the underscore "_" charater as a separator...

Thank you in advance for your help!

Publicado em

Sem comentários