Re: [libreoffice-users] Re: Form fields not filled

On Thu, 2019-07-18 at 16:53 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > OpenSUSE provides only the ODBC connector for mariadb, no JDBC
> > connector.
>
> I'm using only JDBC with OpenSUSE. You have to dowload it directly
> from
> MariaDB
> > What I saw was:
> >
> > SELECT * <tablename>.*, <tablename>.<Field1>, <tablename>.<Field2>
> > FROM
> > <schema>.<tablename> <tablename> ORDER BY <Field1> ASC, <Field2>
> > ASC
> >
> > After deleting the text ', <tablename>.<Field1>,
> > <tablename>.<Field2>'
> > from the SQL query, the extra fields were not displayed on running
> > the
> > query. But on saving the query again, the deleted text was added
> > again,
> > and it's back to square one.
> >
> > Is this a bug? 
>
> Yes, it is a buggy behaviour of the editor. Have tested this: Created
> a
> query for MariaDB, tried to set a field to "unvisible", which should
> only be used to sort the query, but it doesen't work.
> The behaviour is the same in the internal Firebird database, but it
> will
> work right with internal HSQLDB.
>
> Would your report the bug? I will confirm it.
>
> Regards
>
> Robert
> -- 
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
Bugzilla? What is the link?

Cheers
Harvey

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy