Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
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 regardless ? ;-) (Ts. Of course you get a message, but the file is opened then.) > Ah - you are telling me what it does...I asked what should it do, and > I'll offer my suggestion. > > 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 doc" feature, one could - declare a minimalistic form saying "nothing here for you" as on-open-form - assign a macro to the OnLoad event of the DB doc (or the form), which replaces the form with the switchboard To me, that sounds more like a legitimate solution to the problem you sketched. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] mysqlnative, part II
{ please CC me, not subscribed to d...@dba } Hi, first of all: Andrey, *if* you update the code, please leave the conditionals in makefile.mk for SYSTEM_MYSQL intact. i.e. just not copy your new stuff based on the old one over. thanks. :-( I readded it. I also (temporarily) added a MYSQL_LIB+=-lmysqlcppconn for the system-mysql case. (And changed the header check in configure.in). Now, I ran into an other problem: we need delzip in the dir, says dmake: committed delzip there, too. I also added this patch: Index: mysqlc_driver.cxx === --- mysqlc_driver.cxx (Revision 265375) +++ mysqlc_driver.cxx (Arbeitskopie) @@ -37,7 +37,11 @@ using ::rtl::OUString; #include +#ifdef SYSTEM_MYSQL +#include "cppconn/mysql_driver.h" +#else #include "driver/mysql_driver.h" +#endif #undef OSL_TRACE #define OSL_TRACE(msg) printf("%s\n", (msg)) as the include - currently at least - is not found otherwise. Now the question in this mail (I hacked around it to get further, the oxt builds at least): I get the following build error: Making: ../../../unxlngppc.pro/slo/mysqlc_preparedstatement.obj g++ -fsigned-char -fmessage-length=0 -c -Os -fno-strict-aliasing -DSYSTEM_MYSQL -I../../inc -I/usr/include/mysql -DMYSQLC_VERSION_MAJOR=1 -DMYSQLC_VERSION_MINOR=0-DMYSQLC_VERSION_MICRO=2 -DBIG_JOINS=1 -fPIC -I. -I../../../unxlngppc.pro/inc/mysqlc -I../inc -I../../../inc/pch -I../../../inc -I../../../unx/inc -I../../../unxlngppc.pro/inc -I. -I/home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc/stl -I/home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc/external -I/home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc -I/home/rene/OpenOffice.org/cws/mysqlnative/solenv/unxlngppc/inc -I/home/rene/OpenOffice.org/cws/mysqlnative/solenv/inc -I/home/rene/OpenOffice.org/cws/mysqlnative/res -I/home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc/stl -I/home/rene/OpenOffice.org/cws/mysqlnative/solenv/inc/Xp31 -INO_JAVA_HOME/include -INO_JAVA_HOME/include/linux -INO_JAVA_HOME/include/native_threads/include -I/usr/include -I/home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc/offuh -I. -I../../../res -I. -fsigned-char -pipe -frtti -Wno-ctor-dtor-privacy -fPIC -DLINUX -DUNX -DVCL -DGCC -DC300 -DPOWERPC -DCVER=C300 -DNPTL -DGLIBC=2 -D_PTHREADS -D_REENTRANT -DNEW_SOLAR -D_USE_NAMESPACE=1 -DSTLPORT_VERSION=400 -DPOWERPC -DPPC -DHAVE_GCC_VISIBILITY_FEATURE -D__DMAKE -DUNIX -DCPPU_ENV=gcc3 -DGXX_INCLUDE_PATH=/usr/include/c++/4.3 -DSUPD=300 -DPRODUCT -DNDEBUG -DPRODUCT_FULL -DOSL_DEBUG_LEVEL=0 -DOPTIMIZE -DCUI -DSHAREDLIB -D_DLL_ -fexceptions -fno-enforce-eh-specs -DEXCEPTIONS_ON -o ../../../unxlngppc.pro/slo/mysqlc_preparedstatement.o /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx:72:1: warning: "OSL_TRACE" redefined In file included from /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx:33: /home/rene/OpenOffice.org/cws/mysqlnative/solver/300/unxlngppc.pro/inc/osl/diagnose.h:84:1: warning: this is the location of the previous definition In file included from /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.hxx:33, from /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx:35: /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_resultset.hxx:83: warning: declaration 'struct sql::ResultSet' does not declare anything /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx: In constructor 'connectivity::mysqlc::OPreparedStatement::OPreparedStatement(connectivity::mysqlc::OConnection*, sql::PreparedStatement*)': /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx:96: error: passing 'const sql::ParameterMetaData' as 'this' argument of 'virtual int sql::ParameterMetaData::getParameterCount()' discards qualifiers /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx: In member function 'virtual void connectivity::mysqlc::OPreparedStatement::setNull(sal_Int32, sal_Int32)': /home/rene/OpenOffice.org/cws/mysqlnative/connectivity/source/drivers/mysqlc/mysqlc_preparedstatement.cxx:464: error: 'class sql::PreparedStatement' has no member named 'setNull' dmake: Error code 1, while making '../../../unxlngppc.pro/slo/mysqlc_preparedstatement.obj' Grüße/Regards, René -- .''`. René Engelhard -- Debian GNU/Linux Developer : :' : http://www.debian.org | http://people.debian.org/~rene/ `. `' r...@debian.
Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
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 macros regardless ? ;-) Alex Ah - you are telling me what it does...I asked what should it do, and I'll offer my suggestion. It should refuse to open the file. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
RE: [dba-dev] OpenDocument event assigned macro can not execute - now what?
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 regardless ? ;-) Alex - Message d'origine - De: Drew Jensen Env: vendredi 12 décembre 2008 00:10 À: dev@dba.openoffice.org Objet: [dba-dev] OpenDocument event assigned macro can not execute - now what? 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 your forums so that when ever a user level form is closed the switchboard form is again opened. Set the Switchboard form to close the database file when it is closed. All this so that your users are kept away from the raw tables, queries and such. Now - the user goes and disables macro execution - or loads the file from a directory that does not allow embedded macros to run. What should happen? Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] OpenDocument event assigned macro can not execute - now what?
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 your forums so that when ever a user level form is closed the switchboard form is again opened. Set the Switchboard form to close the database file when it is closed. All this so that your users are kept away from the raw tables, queries and such. Now - the user goes and disables macro execution - or loads the file from a directory that does not allow embedded macros to run. What should happen? Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org