Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> Do you mean I shuold file a issue and do the 'fs' thing :-)

:)
No, I fixed that while passing in a 3.2-targeted CWS (dba32e).

> BTW: "Reportedly, the Alpha version of the driver was able to connect to 
> a remote MySQL server in the internet, using the server's IP address. 
> The Beta version is not able to do this anymore, while, on the very same 
> machine, e.g. the Connector/J works fine for the very same server".
> 
> We had the same problem with the MySql  we installed on a XP machine 
> (for your testing), we could not get acces with the native connector, on 
> the other hand we have a same MySql running but now on a Windows 8000 
> server with no problem for the native connector
> So the difference could comming from not working on XP and well working 
> on Windows8000

I'll look into that, too, but that might touch MySQL code very deeply,
so I am not sure I can do anything before the MySQL-side of our C/OOo
team returns from vacation :-\

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Fernand Vanrie]

Frank Schönheit - Sun Microsystems Germany wrote:

Could reproduce with the table dump you sent me, will put onto the
"known problems" list for the connector, and investigate.



http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues#Standard_Filter_dialog_fails_to_set_a_column_filter:

"The bad news is: That's a bug in OOo itself, which is only triggered by
the way how the driver (legitimately) exposes its database/tables, so,
it cannot be fixed in the driver, but in OOo only."
  

Do you mean I shuold file a issue and do the 'fs' thing :-)

BTW: "Reportedly, the Alpha version of the driver was able to connect to 
a remote MySQL server in the internet, using the server's IP address. 
The Beta version is not able to do this anymore, while, on the very same 
machine, e.g. the Connector/J works fine for the very same server".


We had the same problem with the MySql  we installed on a XP machine 
(for your testing), we could not get acces with the native connector, on 
the other hand we have a same MySql running but now on a Windows 8000 
server with no problem for the native connector
So the difference could comming from not working on XP and well working 
on Windows8000


Greetz

Fernand

Ciao
Frank

  



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

> Could reproduce with the table dump you sent me, will put onto the
> "known problems" list for the connector, and investigate.

http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues#Standard_Filter_dialog_fails_to_set_a_column_filter:

"The bad news is: That's a bug in OOo itself, which is only triggered by
the way how the driver (legitimately) exposes its database/tables, so,
it cannot be fixed in the driver, but in OOo only."

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

>> For the first problem: Which database? 
> MySql native connector , the ODBC connector do not have this problem
> ODBC produce a  statementlike : SELECT * FROM `tbl_leveranciers` WHERE ( 
> `tbl_leveranciers`.`Uithangbord` = 'alphadent' )
> as you see without using the "schema name"

Could reproduce with the table dump you sent me, will put onto the
"known problems" list for the connector, and investigate.

However, seeing that this happens with the MySQL Connector/OOo, I doubt
this is what Robby originally referred to, so my question what he means
exactly remains.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

>> For the first problem: Which database? 
> MySql native connector

Hmm, cannot reproduce. Can you give us a table dump (structure only is
sufficient)?

Thanks & Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Fernand Vanrie]

Frank Schönheit - Sun Microsystems Germany wrote:

Hi Fernand,

  

I suppose Robby is pointing to the use of the "filterering" who have a bug

when making a filter with the GUI OO produce SQL a statement like
SELECT * FROM "pmgdbase"."tbl_leveranciers" WHERE ( 
"pmgdbase.tbl_leveranciers"."Uithangbord" = 'alphadent' )
This gives a error because "pmgdbase.tbl_leveranciers", must been 
"pmgdbase"."tbl_leveranciers"

Same behavior when using the filter in a form
I filled already a related Issue 
 for it



Hmm, 102793 does not seem to describe the quoting problem from above,
sounds like two different problems.

102793 slipped my attention so far, will have a look.

For the first problem: Which database? 

MySql native connector , the ODBC connector do not have this problem
ODBC produce a  statementlike : SELECT * FROM `tbl_leveranciers` WHERE ( 
`tbl_leveranciers`.`Uithangbord` = 'alphadent' )

as you see without using the "schema name"

Which driver? Does somebody know
an issue for this, too?

Thanks & Ciao
Frank

  



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> I suppose Robby is pointing to the use of the "filterering" who have a bug
> 
> when making a filter with the GUI OO produce SQL a statement like
> SELECT * FROM "pmgdbase"."tbl_leveranciers" WHERE ( 
> "pmgdbase.tbl_leveranciers"."Uithangbord" = 'alphadent' )
> This gives a error because "pmgdbase.tbl_leveranciers", must been 
> "pmgdbase"."tbl_leveranciers"
> Same behavior when using the filter in a form
> I filled already a related Issue 
>  for it

Hmm, 102793 does not seem to describe the quoting problem from above,
sounds like two different problems.

102793 slipped my attention so far, will have a look.

For the first problem: Which database? Which driver? Does somebody know
an issue for this, too?

Thanks & Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Fernand Vanrie]

Frank , Mechtilde

I suppose Robby is pointing to the use of the "filterering" who have a bug

when making a filter with the GUI OO produce SQL a statement like
SELECT * FROM "pmgdbase"."tbl_leveranciers" WHERE ( 
"pmgdbase.tbl_leveranciers"."Uithangbord" = 'alphadent' )
This gives a error because "pmgdbase.tbl_leveranciers", must been 
"pmgdbase"."tbl_leveranciers"

Same behavior when using the filter in a form
I filled already a related Issue 
 for it


Fernand

Hi Robby,

  

  I have been an OO user for years and mostly love your package, however I 
recently
ran up against the sort bug in OO 3.1.0 Base.



Excuse my ignorance, but what exactly is "the sort bug in OO 3.1.0 Base"?

Thanks & Ciao
Frank

  



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Mechtilde]

Hello Robby, *,

Robby Robertson schrieb:
> Hello,
> 
> I have been an OO user for years and mostly love your package,
> however I recently ran up against the sort bug in OO 3.1.0 Base.
> Sorting of cells is such basic function of a database that it makes
> me wonder where ya'll are headed with future releases.  All the way
> back to college, my Fortran programming professors in the 70's said
> and experience still says, "make sure the basics are working, and
> then add the bells and whistles."  I realize that OO has become a
> very complex package, but without basic functionality it is
> completely worthless.

What is your concret problem with sorting?

Regards

Mechtilde



-- 
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin für die deutschsprachige QA
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Robby,

>   I have been an OO user for years and mostly love your package, however I 
> recently
> ran up against the sort bug in OO 3.1.0 Base.

Excuse my ignorance, but what exactly is "the sort bug in OO 3.1.0 Base"?

Thanks & Ciao
Frank

-- 
- Frank Schönheit, Software Engineer frank.schoenh...@sun.com -
- Sun Microsystems  http://www.sun.com/staroffice -
- OpenOffice.org Base   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

[dba-dev] OO database sort problem

[Robby Robertson]

Hello,

  I have been an OO user for years and mostly love your package, however I 
recently
ran up against the sort bug in OO 3.1.0 Base.  Sorting of cells is such basic
function of a database that it makes me wonder where ya'll are headed with 
future
releases.  All the way back to college, my Fortran programming professors in the
70's said and experience still says, "make sure the basics are working, and 
then add
the bells and whistles."  I realize that OO has become a very complex package, 
but
without basic functionality it is completely worthless.

Thanks for the hard work and looking forward to the next release,

Robby Robertson



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org