Moin Mike,
mike moller wrote:
I'm a new user with OOo but with a reasonable experience base in
computing generally
I have a configuration of
Windows 2000
MySQL 5.1.11
MySQL ODBC 5.1 driver
OOo 2.4.1
Sun Report Builder 1.0.4
The database is an import from MS Access 2000 migrated to MySQL via
the MySQL Migration Tool
Functionality in OOBase for Tables, Queries and Forms is fine - in
particular I'm able to work in Forms and Queries drawing data from
both tables and views on MySQL. Some cases require me to suppress
OOBase's SQL checking in order to deal with SQL dialect issues between
OOBase and MySQL - eg Cast( xxxx as Date) seems to be an issue
although I can't see why it should be
Now when we come to the Report function of OOBase simple SELECT * type
constructs work fine along with similar ones that name individual
fields and also aliased situations eg SELECT t1.Alp_Name as Alpaca
from talpacadetails as t1
such SQL statements can be extended with WHEREs and ORDER BYs without
any further problems arising
These simple SQL statement return their data quite happily into
reports generated either with the wizard or Sun Report Builder and a
nice list results - doesn't seem to matter if that SQL is in one of
MySQL's views or in an OOBase Query or is defined within the Data
property of the Report in OOBase.
BUT if I use something a bit more elaborate (CAST, JOIN, UNION etc)
for the SQL in any of those situations then I either get execution
errors or else the appearance of a completed report but with blanks in
all the data fields (any label fields do show up on the report just
where they are expected to be)
WTF????? this behaviour doesn't seem to be affected by whether SQL
checking is on or off. BTW these "blank data fields" showing in the
report situations still retrieve the data from MySQL correctly when
test run in the Query windows inside the report's data source property
- as I said WTF???
Dear readers, any suggestions or advice that you may care to offer
will be gratefully received
Could you please give the 1.0.5-beta version of SRB a try? You'll find
it here qa-upload.services.openoffice.org
If that doesn't help, please submit an issue and assign it to me (oj):
Perhaps you even have a example at hand :-)
Best regards,
Ocke
thank you
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
