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

[dba-dev] An API reference for calling the DB Record Search dialog functionality from client scripts?

[Drew Jensen]

Hi,

I haven't begun looking for this - will be doing so tonight.
If anyone has a direct link to where a good starting spot (assuming you 
can make sense of my subject line) it would be very much appreciated.


Thanks,

Dj

-
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