How to establish an activeConnetion on launching Openoffice.org BASE with embedded HSQLDB
"Info@RikHustede" <[email protected]> Thu, 3 Mar 2011 19:40:24 +0100
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <5A2ABB1235B247419622F064D1640197@HustedePC> |
Dies ist eine mehrteilige Nachricht im MIME-Format. ------=_NextPart_000_001A_01CBD9DA.D6DF08B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello together, I'm new here, and i have a serious problem with my Base DB with embedded HS= QLDB. I'm not shure, if the problem exists 'cause of my Hard- and Software combin= ation or if it's a serious bug in Base. Using OOo 3.3-Base, Windows 7 and tryed out JRE 1.6.0_20/22/24 the problem = exists with all of them: When launching Openoffice.org BASE with embedded HSQLDB and directly open a= form or dialog via basic macro,=20 all inserted and changed datas are lost on closing the database document. That means, opening a Form in code does work, and I can see the datas of th= e HSQLDB in the form.=20 They also can be changed. Reopening the form via code shows the changed dat= as, i think they are written to cached tables, but not to the hard disk. By closing the database-document, all added or changed datas are lost. With xray I found out, that there is no "activeConnection" into HSQLDB esta= blished by opening forms or dialogs on this way. When i change once into "Table view", then "thisComponent.currentcontrolle= r.activeConnection" can be seen with Xray, otherwise it's a "Null Object". In this case, all added and changed datas will be written to the embedded H= SQLDB, nothing lost. Does anybody know, how to establish the "activeConnection" via Basic? Rik Hustede -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help ------=_NextPart_000_001A_01CBD9DA.D6DF08B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16722"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"= =20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"= =20 name=3D"Compose message area"> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>Hello together,</FONT></DI= V> <DIV><FONT color=3D#080000 size=3D2 face=3DArial></FONT> </DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>I'm new here, and i have a= serious=20 problem with my Base DB with embedded HSQLDB.</FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>I'm not shure, if the prob= lem exists=20 'cause of my Hard- and Software combination or if it's a serious bug i= n=20 Base.</FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>Using <FONT color=3D#08000= 0 size=3D2=20 face=3DArial>OOo 3.3-Base, Windows 7 and tryed out JRE 1.6.0_20/22/24 = the=20 problem exists with all of them:</FONT></FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial> </DIV> <DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>When launching Openoffice.= org BASE=20 with embedded HSQLDB and directly <STRONG>open a form</STRONG> or dialog=20 <STRONG>via basic macro</STRONG>, </FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial><STRONG>all inserted and c= hanged=20 datas are lost on closing the database document</STRONG>.</FONT></DIV><FONT= =20 color=3D#080000 size=3D2 face=3DArial></FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial></FONT> </DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>That means, opening a= Form in=20 code does work, and I can see the datas of the HSQLDB in the form.=20 <DIV><FONT color=3D#080000 size=3D2 face=3DArial>They also can be changed. = Reopening=20 the form via code shows the changed datas, i think they are written to cach= ed=20 tables, but not to the hard disk.</FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>By closing the database-do= cument, all=20 added or changed datas are lost.</FONT></DIV></DIV> <DIV><BR>With xray I found out, that there is no "activeConnection" into HS= QLDB=20 established by opening forms or dialogs on this way.</DIV> <DIV> </DIV> <DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>When i change once i= nto "Table=20 view", t</FONT><FONT color=3D#080000 size=3D2 face=3DArial>hen=20 "thisComponent.currentcontroller.activeConnection" can be seen with Xr= ay,=20 otherwise it's a "Null Object".</FONT></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>In this case, all added an= d changed=20 datas will be written to the embedded HSQLDB, nothing lost.</FONT></DIV> <DIV> </DIV></DIV></FONT> <DIV> <DIV> </DIV></DIV> <DIV><FONT color=3D#080000 size=3D2 face=3DArial>Does anybody know, how to = establish=20 the "activeConnection" via Basic?</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Rik Hustede</DIV> <DIV> </DIV> <DIV> </DIV></FONT></BODY></HTML> ------=_NextPart_000_001A_01CBD9DA.D6DF08B0--