Re: How to establish an activeConnetion on launching Openoffice.org BASE with embedded HSQLDB

Hello Rik,

> When launching Openoffice.org BASE with embedded HSQLDB and directly
> *open a form* or dialog *via basic macro*,
> *all inserted and changed datas are lost on closing the database document*.
> ...

There are various ways how you could do this. I tend to saying that in
neither case, the changes you do to the data should be lost. (Though
there might always be strange ways you could do things, and sometimes,
caring for each such strange way might be ... expensive.)

> Does anybody know, how to establish the "activeConnection" via Basic?

ThisComponent.CurrentController.connect() is the preferred way, it does
effectively the same as is done when you connect via the UI. From this
point onwards, all sub components, including the forms you open
programmatically, use the very same connection, so your data problem
should vanish.

Ciao
Frank
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help