Table does not display all columns from MariaDB server

Discuss the database features

Table does not display all columns from MariaDB server

Postby Klavs » Wed Jul 26, 2017 1:27 pm

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
Klavs
 
Posts: 4
Joined: Fri Jul 07, 2017 5:18 pm

Re: Table does not display all columns from MariaDB server

Postby UnklDonald418 » Wed Jul 26, 2017 6:28 pm

The GUI table designer has a number of limitations, especially when using JDBC and ODBC connections.
There is one explanation
https://forum.openoffice.org/en/forum/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.5 & LibreOffice 6.0.4.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 965
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: Exabot [Bot] and 6 guests