Re: Different table naming between Native Mysql and Mysql ODBC drivers

Frank Schönheit - Sun Microsystems Germany <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hi Fernand,

> Can the difference in Table naming between The Native Mysql driver and 
> the ODBC driver been changed ?
> 
> the Native connector uses "DatabaseName.TableName"
> 
> the ODBC uses "TableName".
> 
> In Forms based on a SQL statement it gives (so far) no problems, but in 
> Forms where the data point to the "Table" there is a issue !

Since with the native connector, you can see tables for more than one
database, omitting the database name would not be possible. Perhaps
we'll add an option in a later version, to limit the tables to one
database. In this case, an additional option to completely hide the
database might be an option.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.