Hi ,

I can't reproduce it.
I can close the office after I have open a 2.4.1 database connected to mysql via
jdbc.

Can you please attach the database as a bugdoc or gives us any more information
about the database (f.e. a sqldump from mysql).

Bye Marc
BTW: please read
http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-BasicRules.html#one_per_issue

Hi there

I've also tried this with the latest development version DEV300_m36, and still
the same issue.

I will try and upload the database tomorrow. Please note that this is indeed 1
issue, there is no issue connecting to the MySQL database, but basically I have
forms, which when opened individually can be opened and closed, however, running
a macro from the form, then renders that form uncloseable, for want of a better
word. It's as if the database application becomes detached from the new style
dashboard screen.

I will have to upload, the OOBase file, a basic library to install, and 2 MySQL
databases for you to test. How would I upload these?

Thanks

Created attachment 58535 [details]
OpenOffice database file, mysql database creation scripts, basic library

Hi there

As promised, here is the attachment of all the relevant files.

There is:

aircraft_log_database.odb - the oobase file

mylgback_empty_dmp.sql & mylglogs_empty_dmp.sql - The 2 mysql database creation
scripts for the databases mylgback & mylglogs

Folder alldb which contains the OOBasic library alldb

Hope this helps

Thanks

Tony

Has anybody tested this yet?

I look at your attached files

I don't understand why I should create *two* databases to do the tests.

And another point: Please reduce to this part which causes the problem. A
reprodution with the internal HSQL is another possibility.

A short step-by-step description help to reproduce it.

Example:
1. MySQl version, JDBC version, OOo version, OS
2. How you define the connection?
3. what do you do exactly (maybe what you expect what happens)?
4. describe the forms which causes the problem
5. when do you start the basic programm?
6. What do you mean with "database application"?

You see there are many question only for trying to understand what you want to do.

Ok.

HSQL database, doesn't support all I need to be able to do, including having
multiple database sources, mysql gives me that opportunity, by using the mysql
database names in the 'sql commands'.

1. MySQL Version 5, OS Fedora 9 & 10, Ubuntu 8.04 & 8.10, Windows XP & Vista.
   OO Version any version 3 or 3.1beta that I have so far tried.

2. There are 2 databases, 1 that would contain static data, the other user data.
There is no problem with using the 2 databases, even though OOBase doesn't
explicitly support linking from multiple databases. And, I also wanted to give
the database exactly as it is. THe database are easy to create, and take up no
room, as I created database exports with no data.

3. The connection is defined through the standard OpenOffice connection
configuration, with mylglogs as the database connected directly to.

4. I open the file using OOBase. I then open the form 0_Startup
   4.1 Click on the 'Start the database.
   4.2 Once the new form has opened (Click 'leave full screen') You can then
close the open form, but you cannot clost the OOBase file.
      The same happens when I run it without using the 'Full screen' option.

5. When do I start the basic program? Not sure what you mean there.

6. Database application as in OOBase !!

When the application hits this problem, I am unable to access the new style
OPenOffice splash screen.

I should also add

This application works exactly as it should in OO 2.2 onwards.

Hi there

Any progress?

Cheers

There are different problems to install all your files on my system

Can you break down the problem to a smaller example. As I see till now nobody
understand your problem.

And also you don't answer all my questions.

>>2. How you define the connection?
What do you mean with "OpenOffice.org standard connection"?

>>4. describe the forms which causes the problem

>4. I open the file using OOBase. I then open the form 0_Startup
This file is part of the *.odb? Does this file start the macro?

>   4.1 Click on the 'Start the database.
Is the "Start-Button" ion the form? Or what do you mean?

>   4.2 Once the new form has opened
Which new file?

> (Click 'leave full screen') You can then
> close the open form, but you cannot clost the OOBase file.

Which forms are open? which forms do you want to close 

>>5. When do I start the basic program?
 >Not sure what you mean there.

Starting a basic programm from a document lock the document.

> 6. Database application as in OOBase !!

OpenOffice.org isn't a database application but a database front end. The
application ca be the application you programm (your document). so what do you mean?

So I think this is a problem which has to discuss on our public mailinglist
users@dba.openoffice.org and not here in the issuezilla.

This is an ask for support not an issue

Hi there

Firstly, I don't see this as a support issue, but as a defect, as an OODb file
which worked perfectly well in OODb 2.2->2.4.2, now doesn't work, is broken.

I did answer all your questions.

1. I don't need to do anything to 'define the connection' I select MySQL jdbc
connection from the list of available options. The database is registered via
the Open Office options as 'aircraft_log_database' You can use the mysql
username root, or any other username that you give permissions to the MySQL
databases.

2. Each and any of the forms suffer the same issues, as soon as a macro has been
run, certainly if navigating between forms.


3. The 'Start button is on the 0_Startup form yes, have you actually opened this
odb file?

4. Once the New form has opened, which file? not a new file, simply a new form,
which if ths odb had been tested you would see.

5. Again each and any form, not form specific.

6. The basic program, whic I assume to be a macro, is run, once the button on
the form is clicked.

7. I think this is just semantics, in the same way that most peaple would view
OOCalc as an application, or Firefox as an application, I'm referring to OOBase
as an application, perhaps I should have said, the OOBase component of the
OpenOffice application.

Please actually test this, as I have said, I have tried this on a variety of
operating systems, and each time yields the same result. The issues are very
easy to replicate. For comparison, try the same odb file in a OpenOffice 2.4
installation, and here you will see how it should be working, and it works
successfully on a variety of operating systems.

Until this is resolved, I cannot move to OO3, and at this rate I'm gooing to
have to seriously consider running any database front ends in Microsoft Access,
in a virtual machine, which is not what I wanted to do, as I was in the process
of re-writing my MS Access front ends into OpenOffice Base 2.4, but if all this
work is rendered useless in OpenOffice 3 then I might have to revert to using MS
Access, and look for alternatives to OO.

I have been using OpenOffice, even before the 1.0 release, and I am a big fan,
and really push it to people I know and deal with, and I really want it to
continue from strength to strength.

Regards

Tony

Hi there

Well, I've found a work around, I have to admit I cam very close to giving up an
OOBase, as it's already appreciably more difficult to use than MS Access, and
the other issues I've raised over time have not been looked at, but I want to
use Linux, and not rely on Wine or VirtualBox, so for now at least I'll continue
to persevere with OOBase.

I hope that on the next update to OOBase I don't have to trawl through to recode
my Macros to get them to work. As I said, I'm a big fan of OO, and in the main
it's a fantastic product.

Cheers

sorry, I didn't read every comment but understand the gist to be that in the
transition from OO.o 2.x -> 3.x some changes where required to Basic macros.

@tony_52, Mechtilde: Is there still a possible issue here - or can this be
resolved as working?

@ atjensen
@ all

As I understand this reports it is an invalid issue
in version 2.x it was only possible to save macros in a concrete form. in
version 3.1. and further it is also possible to save macros in the *.odb file.

that was also the reason why i ask for more precious description which form
contain which macro and what I have to do step-by-step

and:
the native MySQl-connector is only available since 3.1.

Before this version you had to choose between the JDBC or ODBC driver of MySQL.
there was no "standard connection" which OpenOffice.org as the reporter wrote.

works for me

-> closed