Hello together, I'm new here, and i have a serious problem with my Base DB with embedded HSQLDB. I'm not shure, if the problem exists 'cause of my Hard- and Software combination 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, 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 the HSQLDB in the form. They also can be changed. Reopening the form via code shows the changed datas, 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 established by opening forms or dialogs on this way. When i change once into "Table view", then "thisComponent.currentcontroller.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 HSQLDB, 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
