Table does not display all columns from MariaDB server

Discuss the database features
Post Reply
Klavs
Posts: 4
Joined: Fri Jul 07, 2017 5:18 pm

Table does not display all columns from MariaDB server

Post by Klavs »

I have MySQL (MariaDB) database on a server. Tables there have columns of Timestamps. However when I open the tables in Libreoffice the timestamp columns are missing. Forms display the timestamps correctly, though. What is wrong with the tables?
LibreOffice 5.2.7.2 on Mac OS Sierra
UnklDonald418
Volunteer
Posts: 1549
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Table does not display all columns from MariaDB server

Post by UnklDonald418 »

The GUI table designer has a number of limitations, especially when using JDBC and ODBC connections.
There is one explanation
viewtopic.php?f=83&t=61183
beginning at the 4th paragraph.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply