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 thank you -- Mike Moller Lallybroch Alpacas New Zealand www.lallybroch.co.nz --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
