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

2009-01-05 Thread Fernand Vanrie
Hallo Drew, After a few weeks strugling to try simply pass this second connection to the form. if finaly comme back to you . Once a form is opened with a connection it seems to be imposible to pass a new connection . Frank S. replyed: You cannot do this. ActiveConnection is only accepted

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

2008-12-22 Thread Fernand Vanrie
Drew, you wrote 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. Any idea if this second connection also can been used for SQL

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

2008-12-19 Thread Fernand Vanrie
Drew Jensen wrote: ps - sure looks like a ripe candidate for a small example project, doesn't it. Yes, but how can we replicate the MS SQL :-) and Thanks for your advices Fernand - To unsubscribe, e-mail:

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

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

2008-12-16 Thread Frank Schönheit - Sun Microsystems Germany
Hi Drew, Embedded macros. The current development builds for OO.o 3.1 (DEV300_m37) includes both macro libraries being embedded in the ODB file, versus the individual forms, and supports document events (open document, etc) for the ODB file. Unless really server issues pop up with this

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

2008-12-15 Thread Fernand Vanrie
Hallo Drew, Frank We have developed a a implementation as described by Drew, wath sould be the best practice at this day to keep or users a far as possible from our Tables etc.. Second question: waths the actual situation of having macro's in the base document (OO 3.0) it self ? Greetz

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

2008-12-15 Thread Drew Jensen
Fernand Vanrie wrote: Hallo Drew, Frank We have developed a a implementation as described by Drew, wath sould be the best practice at this day to keep or users a far as possible from our Tables etc.. Second question: waths the actual situation of having macro's in the base document (OO 3.0)

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

2008-12-14 Thread Frank Schönheit - Sun Microsystems Germany
Hi Drew, Thinking about achieving my goal then it seems there is a second property that wold be needed at the ODB file level. Hide Base window ( Yes / No ) Okay, I wasn't explicit about this, but I fully agree that this is a necessity for addressing your scenario. Finally, it would be

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

2008-12-12 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: It should refuse to open the file. Uhm. I'd have a hard time implementing a logic like do not open this document when you cannot execute on-load-macros, this sounds ... strange. However, together with a open a form when opening the DB

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

2008-12-11 Thread Drew Jensen
Here is the scenario - You have downloaded OpenOffice.org 3.1. You installed the Switchboard extension. You created a Base database file setting. Developed your embedded scripts to handle the business logic in your database. Used Switchboard to generate your opening screen. Carefully crafted

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

2008-12-11 Thread Drew Jensen
Alex Thurgood wrote: Errrm, logically, it shouldn't run the macros. Ideally, you would get a message telling you that macros have been deactivated or that you don't have the rights to run MyMacro etc, but wait, let me guess, OOo just crashes without warning ? Or better still, it runs the

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

2008-12-11 Thread Frank Schönheit - Sun Microsystems Germany
Hi Drew, Errrm, logically, it shouldn't run the macros. Ideally, you would get a message telling you that macros have been deactivated or that you don't have the rights to run MyMacro etc, but wait, let me guess, OOo just crashes without warning ? Or better still, it runs the macros