[libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Harvey Nimmo
I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb using the MySQL (JDBC) connector. A form I had generated in Base needed a new field that had to be added to the source (Base) query and the related (Mariadb) table. Having added the new field to the table using the Base client,

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Dan Lewis
On 7/16/19 1:54 PM, Harvey Nimmo wrote: I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb using the MySQL (JDBC) connector. A form I had generated in Base needed a new field that had to be added to the source (Base) query and the related (Mariadb) table. Having added the new

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Robert Großkopf
Hi Haevey, > > Having added the new field to the table using the Base client, I > expected it to appear in the query which is of the form (SELECT * FROM > ). It didn't until I closed Base and restarted it. How did you add the field? Tools → SQL? Or did you add it in the GUI. If added through Too

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Harvey Nimmo
On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote: > Hi Haevey, > > > > Having added the new field to the table using the Base client, I > > expected it to appear in the query which is of the form (SELECT * > > FROM > > ). It didn't until I closed Base and restarted it. > > How did you ad

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-16 Thread Harvey Nimmo
On Tue, 2019-07-16 at 22:11 +0200, Harvey Nimmo wrote: > On Tue, 2019-07-16 at 21:28 +0200, Robert Großkopf wrote: > > Hi Haevey, > > > > > > Having added the new field to the table using the Base client, I > > > expected it to appear in the query which is of the form (SELECT * > > > FROM > > > ).

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-17 Thread Robert Großkopf
Hi Harvey, couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm Linux. But my MariaDB is a local database. Think it is a problem of the remote-connection to your database. The changing of the table must reach the database and after changing the table inside the database the informat

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-17 Thread Harvey Nimmo
On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote: > Hi Harvey, > > couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm > Linux. But my MariaDB is a local database. Think it is a problem of > the > remote-connection to your database. The changing of the table must > reach >

Re: [libreoffice-users] Table fields from Mariadb to Base

2019-07-17 Thread Harvey Nimmo
On Wed, 2019-07-17 at 09:54 +0200, Harvey Nimmo wrote: > On Wed, 2019-07-17 at 09:09 +0200, Robert Großkopf wrote: > > Hi Harvey, > > > > couldn't see this behaviour in LO 6.2.5.2 on OpenSUSE 15, 64bit rpm > > Linux. But my MariaDB is a local database. Think it is a problem of > > the > > remote-c