Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?

2008-12-18 Thread Drew Jensen

Fernand Vanrie wrote:

Hallo Drew
Thanks for you extended reply. We are developing a Implemenation who 
is based on Micrsoft SQL tables and views and or ODB file is connected 
with ODBC.  Due to the fatc that it are relative small data-tables 
everyting go smootly. I learned a lot having a deeper look at the 
Switcboard macro's . SO mi idea is to have a OO native Basedoc for 
every user and tnen using the Switchboard extension to keep the ODBC 
based  tables away from or users.
We have still to test this approach, just wondering  if we need for 
every user 2 Basedocs (a native and a ODBC conected) or if we can have 
only 2  multiused network based Basedocs  ?



Hello Fernand,


Actually no you don't need 2 ODB files per user.

When a form, query definition, or report, is opened from a script 
(basic, python or JavaScript macro) you pass an instance of an open 
connection object. Normally this is the Active connection for the ODB 
file, but it does not have to be.


So, when the switchboard form loads it could create a second connection 
object. One that is connected to the MS SQLServer. Then when it loads 
the actual forms, etc., simply pass this second connection to the form. 
In fact this also allows you to use getIsolatedConnection (versus 
getConnection) to create a connection that supports AUTO_COMMIT = False 
if you need to - this allows you full control for committing or rolling 
back updates as needed, for instance: multiple table updates as a single 
business transaction. (This same trick works for an embedded HSQL 
database by the way)


You will probably want to use two ODB files when you are building the 
application, but a final step before pushing out to your users will be a 
merge of the forms, query def's, reports into the single ODB file that 
you would distribute.


Taking this one step then, you can have forms and or statements in 
scripts that work with local (embedded HSQL) tables in the same ODB file 
then - a nice way to offer user specific configuration or history data 
in your database.


I hope that helps,

Drew

ps - sure looks like a ripe candidate for a small example project, 
doesn't it.





-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org



[dba-dev] Re: [dba-users] New version of the SRB for testing

2008-12-18 Thread Drew Jensen

Ocke Janssen wrote:


As far as I know this version should be 4 times faster in report 
generating as before. You still need to start Writer or Calc which 
cost most of the time.
And the formula which can be used have been reworked as the wiki page 
for it.



Hi Ocke,

Just wondering if the new functions will flow backwards into SRB 1.0.x ? 
if not then someone should, I suppose, make note on the wiki page which 
functions are available with which release.


Thanks,

Drew


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org



[dba-dev] Re: [dba-users] New version of the SRB for testing

2008-12-18 Thread Ocke Janssen

On 18.12.08 13:18, Drew Jensen wrote:

Ocke Janssen wrote:

Moin,

I uploaded a new version of the SRB to 
qa-upload.services.openoffice.org. This version uses the newest 
sources from Pentaho. Please be aware that this version doesn't work 
with frmdlg cws OOo version, which will be the case next year ;-) 


Merry Christmas and Happy New Year then...

Same to all here on the list and to you of course. :-)



Different cwses.

As far as I know this version should be 4 times faster in report 
generating as before. You still need to start Writer or Calc which 
cost most of the time.
And the formula which can be used have been reworked as the wiki page 
for it.


As always feel free to submit issues when you encounter them. Perhaps 
you could attach a sample with the formula inside, makes things a lot 
easier for to handle it. Thanks to Drew, for his samples so far.


Best regards,

Ocke



Go have an egg-nog!

No, thanks. I know better things ;-)

- oj




-
To unsubscribe, e-mail: users-unsubscr...@dba.openoffice.org
For additional commands, e-mail: users-h...@dba.openoffice.org




--
Ocke Janssen  Tel: +49 40 23646 661, x1
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:ocke.jans...@sun.com
D-20097 Hamburg   http://www.sun.com/staroffice

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, 
D-85551 Kirchheim-Heimstetten

Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org



[dba-dev] Re: [dba-users] New version of the SRB for testing

2008-12-18 Thread Drew Jensen

Ocke Janssen wrote:

Moin,

I uploaded a new version of the SRB to 
qa-upload.services.openoffice.org. This version uses the newest 
sources from Pentaho. Please be aware that this version doesn't work 
with frmdlg cws OOo version, which will be the case next year ;-) 


Merry Christmas and Happy New Year then...


Different cwses.

As far as I know this version should be 4 times faster in report 
generating as before. You still need to start Writer or Calc which 
cost most of the time.
And the formula which can be used have been reworked as the wiki page 
for it.


As always feel free to submit issues when you encounter them. Perhaps 
you could attach a sample with the formula inside, makes things a lot 
easier for to handle it. Thanks to Drew, for his samples so far.


Best regards,

Ocke



Go have an egg-nog!



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org



[dba-dev] New version of the SRB for testing

2008-12-18 Thread Ocke Janssen

Moin,

I uploaded a new version of the SRB to 
qa-upload.services.openoffice.org. This version uses the newest sources 
from Pentaho. Please be aware that this version doesn't work with frmdlg 
cws OOo version, which will be the case next year ;-) Different cwses.


As far as I know this version should be 4 times faster in report 
generating as before. You still need to start Writer or Calc which cost 
most of the time.
And the formula which can be used have been reworked as the wiki page 
for it.


As always feel free to submit issues when you encounter them. Perhaps 
you could attach a sample with the formula inside, makes things a lot 
easier for to handle it. Thanks to Drew, for his samples so far.


Best regards,

Ocke

--
Ocke Janssen  Tel: +49 40 23646 661, x1
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:ocke.jans...@sun.com
D-20097 Hamburg   http://www.sun.com/staroffice

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, 
D-85551 Kirchheim-Heimstetten

Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org