[Solved] Free HSQLDB 0.3.7 problem LO 5.4.2.2

[dreamquartz]

Hi Villeroy,

It appears that every time a new LO is published the changes are such that your macro 'Free HSQLDB' has a problem.

Attached you will find the print screens.

I also have a question.
I would like to make 'Free HSQLBD' part of the database in stead of part of LO. With other words make it portable. Is that possible?

Dream

[Villeroy]

Everything is portable already.

Module "FreeHSQLDB" together with "Helpers" and the dialog does the connection job with a GUI for any active database document (ThisComponent). You are free to distribute the package.
Module "AutoInstall" together with "Helpers" does the connection job without any GUI and for the containing database document (ThisDatabaseDocument). Simply write the document specific values you would enter into the dialog to the constants declarations on top of the AutoInstall module. To call the auto-install macro you are free to use document specific menues, tool bars, (auto start-) events or some button on a form control.
Module "FreeForms" does something different with any database document (ThisComponent).


viewtopic.php?f=21&t=77543

-- Added an auto-install module to this library, very much inspired by the brilliant work of DACM. Copy that module together with the "Helper" module into your distributable database document, adjust the constant values to your requirements and assign the document open event to Sub onDocumentOpen. It offers the same features as the dialog for any distributed package with a Base document, a hsqldb.jar, a HSQL backend and a collection of stand-alone forms with optional registration at the office suite.

Add the 2 modules to your database document. You may need to add some library if your document is free of Basic code so far (just a dummy Standard.Module1). Then Ctrl+Drag&Drop the 2 modules in the macro organizer.
Edit AutoInstall constants.
Assign your document's auto-open event.
Free forms if you want.
Wrap the whole directory (odb, database folder, driver folder and forms) into an archive.

On the target system:
Look up or set up a trusted directory in Tools>Options>Security>[Macro Security...] and extract the archive to a trusted directory. Trusted directories include subdirectories

[dreamquartz]

Everything is portable already.

Module "FreeHSQLDB" together with "Helpers" and the dialog does the connection job with a GUI for any active database document (ThisComponent). You are free to distribute the package.
Module "AutoInstall" together with "Helpers" does the connection job without any GUI and for the containing database document (ThisDatabaseDocument). Simply write the document specific values you would enter into the dialog to the constants declarations on top of the AutoInstall module. To call the auto-install macro you are free to use document specific menues, tool bars, (auto start-) events or some button on a form control.
Module "FreeForms" does something different with any database document (ThisComponent).


viewtopic.php?f=21&t=77543

-- Added an auto-install module to this library, very much inspired by the brilliant work of DACM. Copy that module together with the "Helper" module into your distributable database document, adjust the constant values to your requirements and assign the document open event to Sub onDocumentOpen. It offers the same features as the dialog for any distributed package with a Base document, a hsqldb.jar, a HSQL backend and a collection of stand-alone forms with optional registration at the office suite.

Add the 2 modules to your database document.
Edit AutoInstall constants.
Assign your document's auto-open event.
Free forms if you want.
Wrap the whole directory (odb, database folder, driver folder and forms) into an archive.

On the target system:
Look up or set up a trusted directory in Tools>Options>Security>[Macro Security...] and extract the archive to a trusted directory. Trusted directories include subdirectories

Will look into it.

Thanks,

Dream

PS: what about the LO 5.4.2.2 issue?

[Villeroy]

PS: what about the LO 5.4.2.2 issue?

Which issue? The error? The error message tells you that there is no dialog library named "FreeHSQLDB" in the GlobalScope which is probably correct after you embedded the whole thing in a document and ran it on an office suite with no FreeHSQL installed.

[dreamquartz]

PS: what about the LO 5.4.2.2 issue?

Which issue? The error? The error message tells you that there is no dialog library named "FreeHSQLDB" in the GlobalScope which is probably correct after you embedded the whole thing in a document and ran it on an office suite with no FreeHSQL installed.

Did not migrate just yet to embedded.
The error occurs when moving to LO 5.4.2.2 from LO 5.4.1.2.

Dream

[Villeroy]

If the dialog library exists, then it is a bug and should be reported to the LO issue tracker.
Since the AutoInstall module does not depend on the dialog library, it can be used to make your database packages with HSQL2 portable.

Edit: I just updated to the latest 5.4.2.2 and can not reproduce the problem. You should simply re-install the FreeHSQL package.

[dreamquartz]

If the dialog library exists, then it is a bug and should be reported to the LO issue tracker.
Since the AutoInstall module does not depend on the dialog library, it can be used to make your database packages with HSQL2 portable.

Edit: I just updated to the latest 5.4.2.2 and can not reproduce the problem. You should simply re-install the FreeHSQL package.

Did you check with Ubuntu 16.04 and/or Widows 7 Pro?

I tried it with Ubuntu, but still same problem.

Dream

[Villeroy]

LO Macro organizer, tab "Dialogs" (Ubuntu 16.4)

LOLibOrganizer.png (14.95 KiB) Viewed 4345 times

[dreamquartz]

LOLibOrganizer.png

Had to remove all, and re-install from scratch, but it worked.

Dream

[dreamquartz]

Hi Villeroy,

It appears that every time a new LO is published the changes are such that your macro 'Free HSQLDB' has a problem.

Attached you will find the print screens.

I also have a question.
I would like to make 'Free HSQLBD' part of the database in stead of part of LO. With other words make it portable. Is that possible?

Dream

[Villeroy]

Notice that you actually move objects when dragging them around in the organizer window. Use Ctrl+Drag&Drop in order to copy objects.
Select the [Modules] tab and drag the 2 modules "AutoInstall" and "Helpers" from My_Macros>FreeHSQLDB and drop them into your document while holding the Ctrl+Key.

On the [Libraries] tab you can easily import the whole FreeHSQLDB Basic library into your document. Choose your document from the list box, click the [Import...] button and point either to a FreeHSQLDB package file, to a Basic file in the folder where FreeHSQLDB is installed or point to any other document having lib FreeHSQLDB embedded already. The module "FreeHSQLDB" won't be functional when embedded in a database document, so you may delete that if you bother. You don't need to import the dialog library because that depends on module "FreeHSQLDB".

[dreamquartz]

Notice that you actually move objects when dragging them around in the organizer window. Use Ctrl+Drag&Drop in order to copy objects.
Select the [Modules] tab and drag the 2 modules "AutoInstall" and "Helpers" from My_Macros>FreeHSQLDB and drop them into your document while holding the Ctrl+Key.

On the [Libraries] tab you can easily import the whole FreeHSQLDB Basic library into your document. Choose your document from the list box, click the [Import...] button and point either to a FreeHSQLDB package file, to a Basic file in the folder where FreeHSQLDB is installed or point to any other document having lib FreeHSQLDB embedded already. The module "FreeHSQLDB" won't be functional when embedded in a database document, so you may delete that if you bother. You don't need to import the dialog library because that depends on module "FreeHSQLDB".

I still did not embed it into the database.
I am still working on it. It was the normal extension install that is/was affected by the latest LO.

Dream