Re: [dba-dev] SRB not working with Queries
Andrew , Thanks for your extented reply, I know to make allias field names and yes thats the problem now the SBR works also with my query:. However is this a bug ? or is it a rule that we need capitalised FIELD NAMES ? Greetz Fernand On Fri, Jan 16, 2009 at 11:22 AM, Fernand Vanrie s...@pmgroup.be wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Hello Fernand, From your description I would suspect that the problem is with your column names in the result set. Try opening your query and ensure that you have created aliases for any returned column that uses a function. ie. SELECT AVERGE( FIELD ), COUNT( FIELD) FROM TABLE GROUP BY FIELD Instead try: SELECT AVERGE( FIELD ) AS AVG , COUNT( FIELD) AS CNT FROM TABLE GROUP BY FIELD Of course using the Query Designer you do this by adding the Alias in the cell just below the field selection. I would be surprised if this does not clear up your problems. HTH Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@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] SRB not working with Queries
On 19.01.09 10:07, Fernand Vanrie wrote: Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) And a sample with hsqldb is not possible? - oj Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] DEV300_m39 breaks in evoab2 NResultSetMetaData.cxx
Hi Ariel, DEV300_m39 breaks in connectivity/source/drivers/evoab2 ... if you're not aware of an issue for this - please submit one. This could be fixed as master fix (i.e. directly for m40, not in a CWS). 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] How to keep users away from Tabels ?
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, The functionality supplied with issue 97889 is available in the current development build of OO.o 3.1 (DEV300_m37 with m39 do out in a few days according to an email in lists today's), no, the fix for this was committed to dba31h, which is not yet integrated, so there's no dev snapshot containing this functionality. oops - guess I misread what was being asked, sorry. Så lenge nå, Drew
