[dba-dev] use DriverManager and Native MySQLconnector
Can i use the DriverManager + the Native MySQLconnector to make a connection ? thanks for any hint or link to some documentation Fernand -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl
Frank , Me again: when loading a paramerized statement i have aSQL error Values not set for all parameters so i load aLoaderArguments(1).Name = CommandType aLoaderArguments(1).Value = 2 'com.sun.star.sdb.CommandType.TABLE aLoaderArguments(2).Name = Command aLoaderArguments(2).Value = SELECT distinct * FROM pmgdbase.adv_reden_tbvips WHERE pmgdbase.adv_reden_tbvips.REDENID = ? how do i can load mi ? parametervalue i supose something like aLoaderArguments(6).Name = CommandParameter 1 ??? aLoaderArguments(6).value = sID Grzt Fernand Hi Fernand, Thanks, now i have my Model and can reload, but the reloading do not affects the activecommand ? an not the results So how to make the new Loaderarguments (active) or how to pass a new activecommand to the DatasourceBrowser Ah - I missed, in your original mail, that you actually want to change the command underlying the DSB. The simplest way might be to just set the Command property of the database form (the model you just retrieved) before reloading. A slightly more complex, but cheaper (in terms of runtime resources) solution would be to base the DSB on a parametrized statement (... WHERE REDENID = ?), and then use the XParameters.setInt (or whatever type the REDENID column has) method: oForm = oController.com_sun_star_awt_XTabController_getModel() oForm.setInt( 1, sid ) oForm.reload() my code is now: odlg.getcontrol(Grid2).LoaderArguments = aLoaderArguments2 ' the new arguments with a new SQL statement in it The LoaderArguments are used at the time the DSB is plugged into the frame, and then discarded (at least as far as the DSB is concerned, not sure the FrameControl implementation makes later use of it). Thus, reload does know nothing 'bout changed LoaderArguments, so this doesn't work. oDatasourceBrowser = odlg.getcontrol(Grid2).frame.controller omodel = oDatasourceBrowser.com_sun_star_awt_XTabController_getModel() omodel.reload As said above, oModel.Command =new_command before doing the reload should help already. Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl
Hallo Frank , Point is : my Datsourcebrowser has no model ? I load a DatsourceBrowser in a FrameControl (learned from Ariel) in a Dialog oFrameControl2 = createUnoService(com.sun.star.frame.FrameControl) oDlg.addControl(Grid2 oFrameControl2) Then Grid2 (in my Dialog) is a com.sun.star.frame.FrameControl with no model but a Frame who has a Controler who is a DatasourceBrowser but with no Model ! so i am a bit confused :-) Thanks Fernand Hello Fernand, I try to use the com.sun.star.frame.FrameControl in a dialog acting as a subforms'. So i have 2 Framecontrol's loaded with a dataSource browser based on a SQL-statement When selecting a row in the first FrameControl the data in the second must been refreshed (passing a new SQL-statementto the second Framecontrol). I found no way to do that because the activeCommand off the Resultset is readonly. The DataSourceBrowser supports the css.form.FormController service, thus a css.form.XFormController interface, so the getModel method will return the css.form.component.DataForm which represents the data. This, in turn, has a css.form.XLoadable interface, which supports a reload method. So, something like oDataSourceBrowser.getModel().reload() should do (assuming that oDataSourceBrowser is the controller loaded into your Grid2 control). Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Flat text Database Opening Changes in DataSource Browser
Sinds 3.3 the opening of a Flat Text Database (showing the tables) in the DataSource Browser has changed. Before, when showing the Tables (all the .txt files in a directory) was fast.and no files where locked by OO. Now , OO seems to load in Memory all the tables (.txt files) and locks all the files in the directory what makes a multi-user aproch imposible . With many files in the directory, it takes ages to view the tables also. Is this wanted behavior or should i file a issue ? Greetz Fernand -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
Re: [dba-dev] CWS dba33m needs testing CAST() problem
Ocke, I am happy to test BUT this stuff is new for me :-) Have the Zip downloaded, how do i INSTALL this stuff , using my existing OOO330m17 settings Greetz Fernand Moin, The cws dba33m needs some testing for the issue 115436 (show stopper). It would be great if we could verify that the issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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
Re: [dba-dev] CWS dba33m needs testing CAST() problem
Ocke, after some more testing, i found that things go's far far more speedy than with the installed m17 ? can you see a reason for this behavior ? the only differece is that i see the fact that i have less extentions loaded and less Database registered in your CWS:33dba version. Did you some major speed aprovements or come i al back to some settings ? Greetz Fernand Ocke, i manged to install, no more CAST problems :-) for me at least, hopes others come to the same conclusion Thank you for this quick fix Fernand Ocke, I am happy to test BUT this stuff is new for me :-) Have the Zip downloaded, how do i INSTALL this stuff , using my existing OOO330m17 settings Greetz Fernand Moin, The cws dba33m needs some testing for the issue 115436 (show stopper). It would be great if we could verify that the issue is fixed. I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m. Best regards, Ocke - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company envoriment, everyone uses the same SQL server, same native OO-connector. Everyone works on OO 3.2 without problems, i test 3.3 and have the CAST problem: cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where `mag_news_export`.`DATUM` has a imported data (dd/mm/) hope it helps Fernand Moin, I just have to set the issue to wontfix. :-( The problem seems to be the database. Even with odbctest I get the same results = error and I tested a StarOffice 9.2 which is equal to OOo 3.2, same error as in OOo 3.2.1 and 3.3. Did anyone did an upgrade to a newer MySQL version before the statement stop working? - oj On 08.12.2010 19:04, Fernand Vanrie wrote: Alex , As always, we gave good reasons to use a technique, so let hope the CAST problem will be fixed soon =-) Fernand, Well I also use EXTRACT(), but have found that I still have to CAST the type. If I just use the DATE/TIME functions on their own, the results are inconsistent across the months, especially when adding or subtracting. I haven't kept any of my old queries that did direct application of date addition / substraction because they were of no use to me, so I rewrote them all with CAST and EXTRACT. An example of a current one that works is given below : SELECT CAST(EXTRACT(YEAR FROM CURDATE()) as SIGNED)-CAST(EXTRACT(YEAR FROM Date1) as SIGNED)+1 as 'Renewal Num' FROM mybase where MONTH(Date1) = 12 I do not consider this to be an optimised way of obtaining the result I wanted, but I found it to be the only way that worked reliably for each month of the year, independently of the date provided by CURRENT_DATE. In a more simplified expression, the results were wrong by +/- 1 dependent on the MONTH given and the date provided by CURRENT_DATE. It may be that the underlying cause to this is a problem with date handling by Mysql, and not OOo at all, but I haven't checked this out. Alex - Fernand Vanries...@pmgroup.be a écrit : Alex , its also a fact that there are (better) alternatives for cast Date() convert() or even left() and right() Hi Fernand, Done, but whether it will make any difference ? Its not a blocker because it doesn't cause a crash, or lose your data, but it is surely a regression from 3.2. Alex - Fernand Vanries...@pmgroup.be a écrit : Alexander , It sould be good to send this message also to relea...@openoffice.org there they decide over live and dead :-) greetz Fernand Hi all, Le 08/12/10 13:38, Reizinger Zoltán a écrit : Hi Fernand, It feels to me as I touched in some days ago, and find it, as a known issue with cast in MySQL: http://qa.openoffice.org/issues/show_bug.cgi?id=115436 Zoltan Hmm, this would not be good for me if this is the case because I use a lot of cast statements with date values in mysql. The reason is simple, default typing of the values in date strings used to lead to funny behaviour for me on OOo, which meant that calculations I had in my queries based on the default types led to incorrect results. I was thus forced into using CAST to ensure correct handling. If that functionality has now gone away with the latest dev release, whereas it works in 3.2, and connector 1.0.0, I see no incentive to move to 3.3. Alex - 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 - 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 - 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 - 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
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
Ocke, I was just wondering, my problems with CAST started (i think) after i instaled the very latest (oracle-report-builder-OOO330-m3.oxt)for testing . Now i tried to remove this ORB version but i get a error so i can not test without ORB loaded. just a hint PS. how do i remove this unremovable ORB ?:-) Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company envoriment, everyone uses the same SQL server, same native OO-connector. Everyone works on OO 3.2 without problems, i test 3.3 and have the CAST problem: cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where `mag_news_export`.`DATUM` has a imported data (dd/mm/) hope it helps - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
Ocke, sorry in my code no space , then i typed cast in uppercase(CAST), no difference.. cast(`mag_news_export`.`DATUM` as date) AS `DATUM`, On 09.12.2010 15:28, Fernand Vanrie wrote: Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company envoriment, everyone uses the same SQL server, same native OO-connector. Everyone works on OO 3.2 without problems, i test 3.3 and have the CAST problem: cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where `mag_news_export`.`DATUM` has a imported data (dd/mm/) hope it helps I already fixed the issue and better it looks like it will make it into 3.3 :-) The problem was the space CAST ( doesn't work CAST( - works. - oj PS: cws is dba33m Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] CAST() no longer working with OOO 330m16
Just found that queries who worked for years are halted now (OOO 330m16) using Cast(timestampvalue as date) CAST(timestampvalue as date) use to run in direct SQL mode I think that CAST as date is no longer loved and by mySQL they recommand DATE(timestampvalue) i have some queries around with CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand
Re: [dba-dev] CAST() no longer working with OOO 330m16
hi Zoltán , Indeed with the built-in hsqldb CAST still works, but no longer with a connection (using the native connector) to mySQL ! same situation for OOO 330m16 and m17 Fernand Hi Fernand, The CAST(timestampvalue as date) working for me in windows version of OOo 3.3RC7(m17), with SQL direct, with built-in hsqldb. Regards, Zoltan 2010.12.08. 11:45 keltezéssel, Fernand Vanrie írta: Just found that queries who worked for years are halted now (OOO 330m16) using Cast(timestampvalue as date) CAST(timestampvalue as date) use to run in direct SQL mode I think that CAST as date is no longer loved and by mySQL they recommand DATE(timestampvalue) i have some queries around with CAST , do not know if there are more ? andis it whort a issue ? Greetz Fernand - 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
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
Alexander , It sould be good to send this message also to relea...@openoffice.org there they decide over live and dead :-) greetz Fernand Hi all, Le 08/12/10 13:38, Reizinger Zoltán a écrit : Hi Fernand, It feels to me as I touched in some days ago, and find it, as a known issue with cast in MySQL: http://qa.openoffice.org/issues/show_bug.cgi?id=115436 Zoltan Hmm, this would not be good for me if this is the case because I use a lot of cast statements with date values in mysql. The reason is simple, default typing of the values in date strings used to lead to funny behaviour for me on OOo, which meant that calculations I had in my queries based on the default types led to incorrect results. I was thus forced into using CAST to ensure correct handling. If that functionality has now gone away with the latest dev release, whereas it works in 3.2, and connector 1.0.0, I see no incentive to move to 3.3. Alex - 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
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
Alex , its also a fact that there are (better) alternatives for cast Date() convert() or even left() and right() Hi Fernand, Done, but whether it will make any difference ? Its not a blocker because it doesn't cause a crash, or lose your data, but it is surely a regression from 3.2. Alex - Fernand Vanries...@pmgroup.be a écrit : Alexander , It sould be good to send this message also to relea...@openoffice.org there they decide over live and dead :-) greetz Fernand Hi all, Le 08/12/10 13:38, Reizinger Zoltán a écrit : Hi Fernand, It feels to me as I touched in some days ago, and find it, as a known issue with cast in MySQL: http://qa.openoffice.org/issues/show_bug.cgi?id=115436 Zoltan Hmm, this would not be good for me if this is the case because I use a lot of cast statements with date values in mysql. The reason is simple, default typing of the values in date strings used to lead to funny behaviour for me on OOo, which meant that calculations I had in my queries based on the default types led to incorrect results. I was thus forced into using CAST to ensure correct handling. If that functionality has now gone away with the latest dev release, whereas it works in 3.2, and connector 1.0.0, I see no incentive to move to 3.3. Alex - 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 - 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] Proposal for other TableFilter
Our Tablefilter in a OO-Basedoc (who reflect also in the TableList in the DatabaseBrowser) is very handy to hide some tables However there is a important disadvantage, when there are NEW tables available in the Database, they are not visible in the DatabaseBrowser and in the OO-base-doc (when using a external data source) SO: Can the filter been altered by choosing witch tables we NOT want to see ? New tables will than automaticly been seen . When this is not problematic for other reasons, i will be happy to fill a Enhancement Issue :-) Greetz Fernand
Re: [dba-dev] How to pass password when opening DatasourceBrowser
Hey Frank , Thanks for the respons: Wath i already tryed en yet again tryed oDB = CreateUnoService(com.sun.star.sdb.DatabaseContext) oConn = oDB.GetByName(mysql_native).GetConnection(username,password) Dim aProps(7) as New com.sun.star.beans.PropertyValue aProps(0).Name = ActiveConnection aProps(0).Value = oconn but the browser stays empty ! ( i tryed with table and sql Statement) maybe you did wath i already found out: - worked from a opened Basedoc ? - you tryed first the code with datasourceName and made the connection manualy and then changed he code to activeconnection ? i trye to connect to a MySQL datasource using the Native Connector Greetz Fernand Hi Fernand, For opening a DataSourceBrowser I use following code Dim aProps(6) as New com.sun.star.beans.PropertyValue aProps(0).Name = DataSourceName aProps(0).Value = mysql_native aProps(1).Name = CommandType aProps(1).Value = 2 ' 0 = tabel , 1 = query , 2 = SQL statement (I always recomment using com.sun.star.sdb.CommandType.* here, for better readability of your code) aProps(2).Name = Command aProps(2).Value = SQL statement aProps(3).Name = ShowTreeView aProps(3).Value = false aProps(4).Name = ShowTreeViewButton aProps(4).Value = false (note that ShowTreeView/Button are superseded (though still supported) by Enable/ShowBrowser - http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html#XInitialization) aProps(5).Name = ShowMenu aProps(5).Value = true aProps(6).Name = EscapeProcessing aProps(6).Value = false oDataSourcebrowser = frame1.loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) That works fine excepted that the user is asked for a Username and Password when the datasource is opened ! How can i avoid this behaviour by passing the username and password within my code ? I tryed to use a ActiveConnection where the Username and password are passed... no luck Hmm - I copied your code snipped, and added an ActiveConnection parameter to aProps, containing an already established connection - this worked like charm, as expected. Sure you passed the right object, did not dispose it meanwhile, and the like? Neither UserName or Password are accepted as arguments No, those are indeed not supported. thanks for any hint The ActiveConnection is the way to go, and it usually works - not sure what you do differently, sorry. Ciao Frank - 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
Re: [dba-dev] Native MySQL connector not working with 3.3 beta
Zoltán , The1.0.1 windows version you send me works with the 3.3 beta , now i will do further testing on my existing applications. Thanks a lot Fernand 2010.08.18. 11:21 keltezéssel, Fernand Vanrie írta: Hallo, I am testing the 3.3 beta , loaded the MySQL native connector extention I test it with 1.0.1 version downloaded from qa-upload ftp server, and works well with 3.3. beta. I just checked this version was removed from server, I not find folder from which I downloaded it. I will send it by PM. May be Frank know more on this :) Zoltan But cannot connect to MySQL database who functioned well under 3.2.1 i get a error when testing the connection A driver is not registered for the URL sdbc:mysql:mysqlc:193.168.0.17:3306/mydatabase Are there some changes I mised or is it a bug ? Thanks Fernand - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Native MySQL connector not working with 3.3 beta
Hallo, I am testing the 3.3 beta , loaded the MySQL native connector extention But cannot connect to MySQL database who functioned well under 3.2.1 i get a error when testing the connection A driver is not registered for the URL sdbc:mysql:mysqlc:193.168.0.17:3306/mydatabase Are there some changes I mised or is it a bug ? Thanks Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Where to find all open DB connections and closes them
Now answers so far, so wath's the problem: I opened a DB connection using first the dispatcher to have a Datasourcebrowser and then i fill the grid with data from a registered database connected to a MySQL over the native connector. loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) The resulting activeconnection can been disposed orclosed but the object is still there without any further use.(giving a disposed exeption) even after kiling the object the connection is still open as a sleep connection on the Mysql server and stay there for ever - disabling or enabling the pooling make no differences - the connection stay there until i close OO so: How can i find this half alive connection and kill it without closing OO Thanks again Fernand hallo all, When opening a DatasourceBrowser with the dispatcher using loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) I have a connection opened with the database server. How can i find this opened connection and close it with the API ? I tried and found a activeConnection on the derivided rowset orowset.activeconnection.dispose or orowset.activeConnection.close does nothing the connection stays open on the server site, only closing OO closes this connection Thanks for any hint - 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
Re: [dba-dev] Where to find all open DB connections and closes them
Frank , Thanks a million: the bandit is the native connector :-) with jdbc works like a charm i post a issue as I am in love with the native (high volume + high speed) i will create a Help-db-JDBC to do this small durthy jobs greetz Frernand BTW: noch immer keine Base heimweh ? Hi Fernand, When opening a DatasourceBrowser with the dispatcher using loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) I have a connection opened with the database server. How can i find this opened connection and close it with the API ? I tried and found a activeConnection on the derivided rowset orowset.activeconnection.dispose or orowset.activeConnection.close does nothing the connection stays open on the server site, only closing OO closes this connection Since you say in your other mail that disabling connection pooling doesn't change the behavior, I can't think of any legitimate reason for keeping the connection open - so, it sounds like a bug. And yet more, there's no chance to iterate over opened connections, and forcefully close them (as this would ... irritate a lot of other components). Sorry to say. Interesting question would be whether this also happens with MySQL over JDBC, for instance. (One reason why this is interesting is because the JDBC driver has built-in logging capabilities, see http://wiki.services.openoffice.org/wiki/Logging_JDBC_Activity.) Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Where to find all open DB connections and closes them
hallo all, When opening a DatasourceBrowser with the dispatcher using loadComponentFromURL(.component:DB/DataSourceBrowser, _beamer, 0, aProps) I have a connection opened with the database server. How can i find this opened connection and close it with the API ? I tried and found a activeConnection on the derivided rowset orowset.activeconnection.dispose or orowset.activeConnection.close does nothing the connection stays open on the server site, only closing OO closes this connection Thanks for any hint - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to set a MySQL TIMESTAMP to null
Alex Thurgood wrote: Is this not a bug in that version (which one, by the way) of the ODBC driver ? I have had this problem for a long time, and it has caused me no end of trouble, for example when I switched to the JDBC driver and it couldn't handle default -00-00 strings. It occurs on my system because I have set the default value of my date fields to be NULL in the create table statement. Even my current MySQL Query Browser client has problems with this and throws an error. Alex, I use the native connector, but you are right Date, Time and Timestamps are always trouble. But as adviced by Peter i will check for the datatype in the Resultset, a technic who most work for all drivers ? and be carefull to use the correct update method and thecorrect SQLtype . in a prepared statement y wronly used setString ( 1, 93) 1 is the field and 93 is the Datatype will put 00-00-00 00:00:00 in thet datbasefield it has to be setNull(1,93) set the field to (null) Greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)
Ocke , 00 3.2.1 connected to MySQl over the native Windows Tested here in production envoriment: made a 995 page report = OK a raport with images also OK no big different in speed on my slow double core windows machine in the second-face where the document is build is saw that from time to time (every 30 seconds) 1 proccesor takes all the laod. for 5 secs? But works fine =-) Greetz Fernand Time is rare these days. But I uploaded a new version which I could install and run a simple report (one filed only). So give it a try. :-) - oj Ocke Janssen wrote: It seems that update the sources to newest version doesn't work out of the box. I've to invest some more time I guess. Thanks for the help so far. - oj Reizinger Zoltán wrote: Hi Ocke, Something wrong remains in new version, too. I run existing reports, get error Failed to load style-mapper. Same error when created new report in design view, and try to run. Zoltan 2010.06.22. 14:46 keltezéssel, Ocke Janssen írta: My fault. When things should go fast. ;-( I uploaded a new version. - oj Reizinger Zoltán wrote: Hi Ocke, I tried to install it on DEV300_m83 on win7 and failed, with error I attached here. I tried as user and as admin, failed both case, after thet removed chache folder, from installation, started with empty extension manager, same error. Zoltan 2010.06.22. 12:53 keltezéssel, Ocke Janssen írta: Moin, I've uploaded a new version which uses the newest sources. May someone tries to test it. At the moment I've done the build without testing it. oracle-report-builder-cws-srb1.oxt on qa-upload.services.openoffice.org/SRB Best regards, Ocke Ocke Janssen wrote: Hi Zoltan, On 11/11/09 11:03, Reizinger Zoltán wrote: Ocke Janssen írta: Moin, on qu-upload.services.openoffice.org/SRB you'll find a sun-report-builder-cws-srb1.oxt. It contains the newest offical releases from Pentaho. It would be great if you could test this new version. Hopefully it should as good/worse as the beta version you'll find at the same place. If I understand well, it needs to test with OOO320_m4, now? m4 should work. This new SRB is targeted for OOo 3.3 release. - oj Zoltan - oj - 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 - 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
Re: [dba-dev] How to set a MySQL TIMESTAMP to null
Peter, stupid me, my rowset is client site but the server site resultset gives also 93 as type ? Peter , Thanks for the hint but no luick , the type in the rowset = 93 this gives and still a lot of 0's and no (null) in my table as i use a SQL statement i do not alter the rowset but go over the active conection to the mySQL table. when is use the rowset service to update in stead off a direct SQL statement then the column.updatnull gives a (null) in the table. as the rowset service still gives problems i need to use SQLstatements to alter my tables behind the OO- rowset service runs also a SQLstatement : question is wath type is there used to set the right SQLtype ? Thanks Fernand Hi Fernand, did you query for the type of the column? resultSet.columns.getByName(myCol).Type? oStatement.setNull(1, ) for a textfield works fine ( = long SQLType others) oStatement.setNull(2, ) for a timestamp returns 00-00-00 00:00:00 and not the Mysql (null) i tried SQLtype 0 also with same results Regards Peter - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ORB args ComponentData
Frank , Thanks for this clarification, i supose (hope) they are working on this feature ? btw. we can chnage the component parameters. without opening the DBase file. We open the Reportthe component is then available we close the report, but the component regist somewhere in memory ad so we can alter the parameters and run the report with the new newparameters Thanks Fernand Hi Fernand, How and in witch format can i provide the ComponentData Argument when using LoadFromURL i try to set the filter to new value Looking into the code, it seems to me that the only parameter in the component data which is respected so far is the ActiveConnection. So, I don't think you can override the report's filter this way. Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)
Ocke, I trie to install on 3.2.1 WINDOWS XP and it can not been installed due to a registry problem:Canot register implementation eXception probably same error as Zoltan ? Ocke , We give it a trie Fernand Moin, I've uploaded a new version which uses the newest sources. May someone tries to test it. At the moment I've done the build without testing it. oracle-report-builder-cws-srb1.oxt on qa-upload.services.openoffice.org/SRB Best regards, Ocke Ocke Janssen wrote: Hi Zoltan, On 11/11/09 11:03, Reizinger Zoltán wrote: Ocke Janssen írta: Moin, on qu-upload.services.openoffice.org/SRB you'll find a sun-report-builder-cws-srb1.oxt. It contains the newest offical releases from Pentaho. It would be great if you could test this new version. Hopefully it should as good/worse as the beta version you'll find at the same place. If I understand well, it needs to test with OOO320_m4, now? m4 should work. This new SRB is targeted for OOo 3.3 release. - oj Zoltan - oj - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] SRB testing
We try to uses SRB in a real life app, so ideal conditions to test future versions, if they are around , where can i find the beta or snapshot releases ? Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Zoltán , Thanks, I over looked the double quotes is my testing because wrong field format also produce blanks For others: when get blank_output then there is a error in the formula or wrong field format when get 0_output then formula is OK but certenly wrong field format. Thanks for the solution and all the work you spended on this usefull Tool Fernand Hi Fernand, The [Textfieldname] [Textfieldname] working for me on windows with OOo 3.2 and SRB 1.2. Zoltan 2010.05.11. 9:58 keltezéssel, Fernand Vanrie írta: Ocke , Sorry but I tried this all before and again =-) : also is not working: Windows - SRB 1.2 -OO 3.2.0 Sould i fill a issue ? Fernand - 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] SRB missing text FUNTIONS
Maybe a stupid question or i looked just over it : but why is a very usefull text Function as CONCAT or CONCATENATE not available in the Sun Report Builder ? I know, there are Queries to do things like that (supposes we build for every Report a new Query...), but Concatenate a part of field with some 'text' or other parts is more handy than some other available text Functions.as URLENCODE etc... Joining the field parts as separate controls is al so a work around but by making URL's for pictures we need to do something like concat('///myserver/mydirectory ; LEFT(TEXT[urlFIELD]);10); 'etc...') Hope it helps to improve SRB and thanks for all the exellent work done to make this tool available! Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] UnoComponent: invoking from form control
Peter , The evenst are there and they Works fine for me on Windows ? They are there not working GridControllcolumns only on the gridcontroll itself Fernand Hi, in Uno dialogs you can bind an event to a dialog control: either a macro or a method of a uno component. In form controls I'm missing the latter. Any hints? (hoping Frank is reading here yet) Regards Peter - 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
Re: [dba-dev] SRB Details do not stay together on a page
Zoltán , Thanks, I played a bit with the problem and in fact its simple to avoid spliting if we users can calqul a bit : is supose the field height as always fix not variable with the lenght of the content ? so yes: then a non-spliting Fullnumber of Details = (pageheight -HeaderH-FooterH-groupH)/ DetailsH i tested, works fine a condition we print the grouping on every page hope this anoing bug wil be fixed soon Fernand 2010.04.22. 19:49 keltezéssel, Fernand Vanrie írta: OO 3.2 and SRB latest version I found that when placing multiple fields in theDetails' sector of a report the Keep Together do not works properly It is known bug, not solved until now: http://qa.openoffice.org/issues/show_bug.cgi?id=98959 Zoltan - 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
Re: [dba-dev] Re: And now what?
Andreas , Your proposal is maybe a bit to drastic, but OO can, indeed, been a ideal frontend for any DB, included a Oracle Base :-), I hope they reed this dispared crys and gives us some exctra developer power. Fernand Drew Jensen wrote: Hi, Ok - so 50% of the developer team is now gone. Anyone want to take a crack at where that leaves us? Come on now - everyone has had a day to think about it. Drew Drop embedded HSQLDB and make the rest working for experienced database developers (macros forms) and for the ordinary mail merger (reliable filters, connections and sort orders). My 2 Cents, Andreas S. - 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
Re: [dba-dev] Confirming Oracle issue
Peter, Its seem logical to me that a time field not can handle date information but maybe i miss understood your question ? In general database stored times/dates and the way OO handles this things is for me :-) a blackbox. Therefore i alwayqs uqe cDate(databasefield) as a start for futher handling. Greetz Fernand Hi, anybody from the base team there who can confirm http://www.openoffice.org/issues/show_bug.cgi?id=109185 Thanks Peter - 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
Re: [dba-dev] XOutParameters
Peter , This thinks are not working, i filed issues for it if it is urgent you can try my work around SUB TESTstoredprocedurecall oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext) oDB = oBaseContext.getByName(mysql_native) oCon = oDB.getConnection(user, Password) oStatement = oCon.createStatement() sSQL1 = call teststoredprocedure('Parm1', '¨Parm2') ' must been pased in right order ostatement.execute(sSQL1)' gives True oResultset1 = ostatement.getresultset oResultSet1.next print oResultset1.getstring(1)' confirmes the selection based on parameters ostatement.close ' must been done otherwise we ran in a Exception:'sdbc.SQLExepetion Commands out of sync, you can not run this command now 'after this exception you need to restart OO or dispose oDB ocon.close ' just to be sure everyting isclosed end sub Hope it helps Fernand Hi Frank, hi Ocke, Java has a method registerOutParameter(int,int), which e.g. works with Oracle jdbc like registerOutParameter(1,OracleTypes.CURSOR). Interface XOutParameters needs a third parameter typeName, which I tried with registerOutParameter(1,com.sun.star.sdbc.DataType.REF,oracle.jdbc.OracleTypes.REF). Invalid name pattern is the answer from sdbc. It's my first contact with stored procedures, so perhaps you can give me a hint how to handle this. Regards Peter - 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] How to load a SRB report from his com.sun.star.comp.report.OReportDefinition
I trie to make a macro who load and runs a SRB report, but changing the filter with data from the macro i got to the com.sun.star.comp.report.OReportDefinition wher i can change the filter string but how can i load en run the report. Do i hav to store the Definition back to the storage and reopen the reportDoc ? ok i got so far: Sub Main dim Arguments(2) as New com.sun.star.beans.PropertyValue context = createUnoService(com.sun.star.sdb.DatabaseContext) oDataBase = context.getByName(mysql_native) oDBDoc = oDataBase.DatabaseDocument oReports = oDBDoc.getReportDocuments() Arguments(0).Name = OpenMode Arguments(0).Value = open Arguments(1).Name = ActiveConnection Arguments(1).Value = oDatabase.getConnection(user,password) Arguments(2).Name = Hidden Arguments(2).Value = false oreport = oreports.getbyname(Myreport) oreportComponent = oreport.component oreportComponent.Filter = pmgdbase.mag_jobs.JOBNR LIKE 'MMTbe%' Arguments(0).Name = Hidden Arguments(0).Value = false oreportComponent.load(Jobbons1,,,Arguments()) 'here i fails to laod the report ' here I can store the Definition ' and reload ? ' oReport = oReports.loadComponentFromURL(Jobbons1,_blank,0,Arguments()) is that te right way ?? End Sub Thanks for any hint Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
So far i found a lot of things not working with Stored Procedures, but finaly :-) i got a sort of workaround for a Stored Procedure on MySql with parameters. SUB TESTstoredprocedurecall oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext) oDB = oBaseContext.getByName(mysql_native) oCon = oDB.getConnection(user, Password) oStatement = oCon.createStatement() sSQL1 = call teststoredprocedure('Parm1', '¨Parm2') ' must been pased in right order ostatement.execute(sSQL1)' gives True oResultset1 = ostatement.getresultset oResultSet1.next print oResultset1.getstring(1)' confirmes the selection based on parameters ostatement.close ' must been done otherwise we ran in a Exception:'sdbc.SQLExepetion Commands out of sync, you can not run this command now 'after this exception you need to restart OO or dispose oDB ocon.close ' just to be sure everyting isclosed end sub this Exception Commands out of sync, you can not run this command now make the use of PreparedStatements useless I will file a Issue if this is realy a bug. Hope this is usefull information for who trye to use stored procedures Fernand Marc Santhoff wrote: Am Samstag, den 13.02.2010, 18:22 +0100 schrieb Marc Santhoff: And just here i am lost: how works this registering of the parameters ? Dunno, my assumption was that it is not strictly necessary ... I tink someone else has to answer this question. A quick look into chapter 8 of the HSQL docs shows: quote The routine body is a SQL statement. In its simplest form, the body is a single SQL statement. A simple example of a function is given below: An example of the use of the function in an SQL statement is given below: SELECT an_hour_before(event_timestamp) AS notification_timestamp, event_name FROM events; /quote The other SQL statement for calling procedures, in contrast to functions, would be CALL. So chances are good that a prepared statement on the OOo side of things is sufficient for transferring parameters to a statement build up by a stored function or stored procedure call. HTH anyway, Marc Hi Marc That is good for single return values, but not for returning multiple parameters or for returning a cursor to a result set. So, sure there is some access to the stored procedures with the current implementation but it isn't yet ready to take full advantage them - IMO. Thanks, Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Calling a stored procedure returns sdbc.SQLException
I can get a resultset from a Stored Procedure (on MySQL) using a simple Statement or using a prepareStatement: call StoredProcdurename() but only once. after running the statement a second time OO trows a sdbc.SQLExepetion Commands out of sync, you can not run this command now I have to restart OO before this error disapear is tghis a bug or wath am i doing wrong Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
Marc , you told : That makes, in consequence, stored procedures unusable with OpenOffice base. This is countrary to what the DEV guide tells us Stored procedures are server-side processes execute several SQL commands in a single step, and can be embedded in a server language for stored procedures with enhanced control capabilities. A procedure call usually has to be parameterized, and the results are result sets and additional out parameters. Stored procedures are handled by the method |prepareCall()| of the interface com.sun.star.sdbc.XConnection http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html. com::sun::star::sdbc::XPreparedStatement prepareCall( [in] string sql) The method |prepareCall()| takes a an SQL statement that may contain one or more '|?|' in parameter placeholders. It returns a com.sun.star.sdbc.CallableStatement http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/CallableStatement.html. A |CallableStatement| is a com.sun.star.sdbcx.PreparedStatement http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/PreparedStatement.html with two additional interfaces for out parameters: com.sun.star.sdbc.XOutParameters http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XOutParameters.html is used to declare parameters as out parameters. All out parameters must be registered before a stored procedure is executed. greetz Fernand If we talking about General users it could been a good start to make StoredProcedures visible in the GUI before we adding bells like parameters etc I would not call parameters to function calls bells, I would call it a necessity. Other users (who have acces to there own Databases) do not need other than Native Mode because they written already the Stored Procedures in the very same Native SQL Stored procedures usually need parameters, which you can not enter in native mode. That makes, in consequence, stored procedures unusable with OpenOffice base. - Marc Greetz Fernand Hi Marc, Maybe a third mode could help here: Semi-Native SQL, where base would only scan for parameter definitions using the :name scheme. Hmm, don't like this idea too much. Basically, it would be completely intransparent to the user. This is not per se a bad thing :), but if things are prone to failure (and parsing queries which the user said don't even attempt to do *are*), then we should not do them silently, and without a chance for the user to intervene. [0=1] What a hack ;) Well, yes, kind of :). On the other hand, it worked well for a decade or so, and as said, I assume the original authors had reasons for doing it. Still, I'd say we should think about removing it. Ciao Frank - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
Marc, Its even worse ,after further investigation i found no code (API + basic) to run a stored procedure with parameters. So I would be very happy i someone could give a hint :-) thanks for any help Fernand you told : That makes, in consequence, stored procedures unusable with OpenOffice base. Well, I probably need to refine that a bit, indeed: It makes stored procedures unusable in OpenOffice base using the query editor. This is countrary to what the DEV guide tells us Stored procedures are server-side processes execute several SQL commands in a single step, and can be embedded in a server language for stored procedures with enhanced control capabilities. A procedure call usually has to be parameterized, and the results are result sets and additional out parameters. Stored procedures are handled by the method |prepareCall()| of the interface com.sun.star.sdbc.XConnection http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html. com::sun::star::sdbc::XPreparedStatement prepareCall( [in] string sql) The method |prepareCall()| takes a an SQL statement that may contain one or more '|?|' in parameter placeholders. It returns a com.sun.star.sdbc.CallableStatement http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/CallableStatement.html. A |CallableStatement| is a com.sun.star.sdbcx.PreparedStatement http://api.openoffice.org/docs/common/ref/com/sun/star/sdbcx/PreparedStatement.html with two additional interfaces for out parameters: com.sun.star.sdbc.XOutParameters http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XOutParameters.html is used to declare parameters as out parameters. All out parameters must be registered before a stored procedure is executed. greetz Fernand If we talking about General users it could been a good start to make StoredProcedures visible in the GUI before we adding bells like parameters etc I would not call parameters to function calls bells, I would call it a necessity. Other users (who have acces to there own Databases) do not need other than Native Mode because they written already the Stored Procedures in the very same Native SQL Stored procedures usually need parameters, which you can not enter in native mode. That makes, in consequence, stored procedures unusable with OpenOffice base. - Marc Greetz Fernand Hi Marc, Maybe a third mode could help here: Semi-Native SQL, where base would only scan for parameter definitions using the :name scheme. Hmm, don't like this idea too much. Basically, it would be completely intransparent to the user. This is not per se a bad thing :), but if things are prone to failure (and parsing queries which the user said don't even attempt to do *are*), then we should not do them silently, and without a chance for the user to intervene. [0=1] What a hack ;) Well, yes, kind of :). On the other hand, it worked well for a decade or so, and as said, I assume the original authors had reasons for doing it. Still, I'd say we should think about removing it. Ciao Frank - 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 - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures
Marc , We uses also Stored Procedures on a Msql server To make all things work , we handles all user input (parameters calculatutions, translations etc...) with OO-dialogs and some macro's to create the SQL statements writen to please the ODBC driver and the Msql server :-) Good day We develop point of sales (POS) applications using PostgreSQL as the database backend. We thought it could be interesting for our customers to access the database directly from OpenOffice Base to create their own reports etc. But it turns out that OpenOffice Base and PostgreSQL are not playing together nicely: Our database consists of tables (of course..), views, and a substantial number of stored procedures, especially for the more complex reports and such. E.g, to get the balance of all accounts, you would send the following SQL code to the database: SELECT * FROM acf_balance_all() To get the balance from only on account, you would use SELECT * FROM acf_balance('1000') ('1000' is the account number). When I enter the SQL code in the query editor in non-native SQL mode, it outputs a syntax error, i.e. it seems to be unable to handle the PostgreSQL stored procedure calls. I can, however, set the query editor to native SQL mode, then the SQL code is passed as is to the database backend and no error is output. But with native SQL mode, I loose the possibility to have OpenOffice ask the user for parameters. I can only use calls without parameters. But most stored procedurs actually require paramates. There is a second (and maybe unrelated) problem: OpenOffice Base seems for each query to send a generated query to the database server to check if that table in the query exists. It does something like SELECT COUNT(*) FROM tablename WHERE 0 = 1 This will of course never return any data, but it will raise an error if tablename does not exist, so I assume this is done to check for the presence of a table. But again, this does not work when a query instead of table specifies a stored procedure in a SELECT. I am using OpenOffice Base on Mac OS X Snow Leopard using the jdbc.postgresql JDBC driver and PostgreSQL 8.4.2 as the database backend. I did not try any native client, since this is a bug that I want to report (and, if possible, see fixed) regardless if a native driver would work. If there are any details I can further provide, or any test I can run, please me know. - 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] Need confirmation about SubForms not working under 3.2 RC1
Just Stumbled on the fact that Subforms are no longer working with 3.2 RC1on a WINDOWS box Normaly i connect to a MySQL server over Native or ODBC but even after cpopying the table to a OO-HSQL file i have the same behaviour To check: make a DBbase and use the wizard to make a Form with Subform based on a one to many field relation. The Subform stays Empty ? Maybe i am just doing something stupid :-) Thanks Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Frank , For months i am looking for the best solutions to manipulating data in Dialogs instead of forms. So i was missing a GridControl. Last week i Readed on Gulfoss that a new AWT UNO Dialog GridControl is coming, I discused with the makers why there is no dataloader available. They told me that this GridControl is a developer tool and we have to build our proper Loading stuff. I can do that but it wil be terible slow using loops over the resultset. Then i stumbled on 2008- discussion between you and Ariel about implementing a DataSourceBrowser in a Uno Dialog. This solution is not only faster but also available NOW Then I was just wondering if we also can use this FormGridView in the same way. Thanks to your knowledge its now (again) all clair for me :-). As Always Thanks Fernand Thanks to what i learned from Frank and Ariel i can open a DataSourceBrowser in a UNO Dialog doing the same for a FormGridView fails in a way that the FormGridView opens in the dialog but without data ? The FormGridView is meant as slave view for an existing and living form, it's the component you see when pressing the Form as Table button in a form document. So, it won't work on its own. I don't know out of my head how you would need to create a proper env for the FormGridView, but can we go one step back, and you explain what you want to achieve? Depending on this, the FormGridView might not be the best choice. Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Noel , Any change your code can been used in Basic ? Greetz Fernand Hi Frank, On Tue, 2009-10-06 at 09:45 +0200, Frank Schoenheit, Sun Microsystems Germany wrote: Hi Fernand, For months i am looking for the best solutions to manipulating data in Dialogs instead of forms. Just this morning, sitting in the subway and having no newspaper to read :), I wondered whether it would make sense to implement the runtime code for all the database controls in dialogs. Adding a full-blown dedicated UI for creating database dialogs would be an additional effort, but perhaps it would be valueable having only the runtime, i.e. the ability to programmatically create and execute such dialogs. As a first step, at least. This sounds a little familiar to something we discussed on this list in the past ( it wasn't exactly the same thing, but if you remember we talked about using form control models ( especially data aware ones ) with the toolkit controls in dialogs ) as such, I think supporting database controls is a great idea :-) Btw I use currently use the form control models with the toolkit controls ( and it seems to work well ) in ooo-build, the (self imposed) limitation is that this is only available 'transiently' when importing MSO 'Userform' controls. Not sure if any of the work I have done is that useful in this case but I'd happily attach it/upload [*] etc. somewhere should you want it or think it's useful. In anycase I am interested in upstreaming this code anyway but I was thinking about doing that in the context of a future vba support CWS. However, as I said at the moment it really isn't suitable to be used with Openoffice directly ( lack of ui/persistence support for one ) and I haven't had the time to concentrate on that part of it :-/ It sounds though that any work in this area would be relevant to ( and affect ) a 'proper' solution for what I would like to do, so I am very interested Noel [*] currently I don't recall exactly what I have in terms of changes but iirc it's just a cheap and nasty solution to use the appropriate (form) models when the dialog is in vba mode - 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] Opening a GridControl in a UNO Dialog
Hallo all, Thanks to what i learned from Frank and Ariel i can open a DataSourceBrowser in a UNO Dialog doing the same for a FormGridView fails in a way that the FormGridView opens in the dialog but without data ? Wath I am doing is loading a .component:DB/FormGridView in a UNO Dialog ControlFrame using the same mediadescriptor (LoaderArguments) as for the DataSource Browser, wath are I missing?? the code based on the work of Ariel Constenla-Haile Sub DataSourceBrowser_FrameControl Dim oDlg as Object, oGhost as Object, oFrameControl as Object Dim aPosSize Dim oFrame as Object, oController as Object, oModel as Object DialogLibraries.loadLibrary(Standard) oDlg = createUnoDialog(DialogLibraries.Standard.DBTABLEPREVIEWDIALOG) ' dialog with a Frame_control init namend WIN_BEAMER oGhost = oDlg.getControl(WIN_BEAMER) aPosSize = oGhost.getPosSize() oFrameControl = createUnoService(com.sun.star.frame.FrameControl) oDlg.addControl(FRAME_CTRL, oFrameControl) oFrameControl.setPosSize(aPosSize.X, aPosSize.Y, aPosSize.Width, aPosSize.Height, _ com.sun.star.awt.PosSize.POSSIZE) Dim aLoaderArguments(5) as New com.sun.star.beans.PropertyValue aLoaderArguments(0).Name = DataSourceName aLoaderArguments(0).Value = MyRegisteredDatabase aLoaderArguments(1).Name = CommandType aLoaderArguments(1).Value = com.sun.star.sdb.CommandType.TABLE aLoaderArguments(2).Name = Command aLoaderArguments(2).Value = My_table aLoaderArguments(3).Name = ShowTreeView aLoaderArguments(3).Value = FALSE aLoaderArguments(4).Name = ShowTreeViewButton aLoaderArguments(4).Value = FALSE aLoaderArguments(5).Name = ShowMenu aLoaderArguments(5).Value = FALSE 'This property is not documented in the IDL 'http://api.openoffice.org/docs/common/ref/com/sun/star/frame/FrameControl.html oFrameControl.LoaderArguments = aLoaderArguments 'oFrameControl.ComponentUrl = .component:DB/DataSourceBrowser oFrameControl.ComponentUrl = .component:DB/FormGridView oFrame = oFrameControl.Frame If NOT IsNull(oFrame) Then oController = oFrame.Controller If NOT IsNull(oController) Then oModel = oController.Model If NOT IsNull(oModel) Then'here is NULL: the DSB has no model '... End If End If End If End Sub - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Sun Connector for mySQL Column Default and Description not passed
Hallo, After a quick check for some essentials needed for a new project I found that the Default and Comment settings from the original mySQL column are not passed to the com.sun.star.sdb.OTableColumnWrapper properties known as DefaultValue and Description. BTW : the mySQLODBC driver passes the Default but also not the Comment Is this a already known problem or sould I fill a issue ? greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Sun Connector for mySQL Column Default and Description not passed(correction)
Sorry Defaultvalues are passed for Native and ODBC Comment are NOT passed for both drivers Hallo, After a quick check for some essentials needed for a new project I found that the Default and Comment settings from the original mySQL column are not passed to the com.sun.star.sdb.OTableColumnWrapper properties known as DefaultValue and Description. BTW : the mySQLODBC driver passes the Default but also not the Comment Is this a already known problem or sould I fill a issue ? greetz Fernand - 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] Resultset FetchDirections
Hallo all, The DEV guide told us to set the approriate FetchDirection in the Statement object. OK: but where can I find more information about this Fetch settings ? FetchDirectionlong 1000= only downwards FetchSizelong 1= ?? Or is the FetchDirection automaticly set by the ResultsetType in the Statement object where we can choose between 3 Scrolling types : FORWARD_ONLY SCROLL_INSENSITIVE #SCROLL_INSENSITIVE SCROLL_SENSITIVE #SCROLL_INSENSITIVE Thanks for any hint Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OO database sort problem
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, I suppose Robby is pointing to the use of the filterering who have a bug when making a filter with the GUI OO produce SQL a statement like SELECT * FROM pmgdbase.tbl_leveranciers WHERE ( pmgdbase.tbl_leveranciers.Uithangbord = 'alphadent' ) This gives a error because pmgdbase.tbl_leveranciers, must been pmgdbase.tbl_leveranciers Same behavior when using the filter in a form I filled already a related Issue http://qa.openoffice.org/issues/show_bug.cgi?id=102793 for it Hmm, 102793 does not seem to describe the quoting problem from above, sounds like two different problems. 102793 slipped my attention so far, will have a look. For the first problem: Which database? MySql native connector , the ODBC connector do not have this problem ODBC produce a statementlike : SELECT * FROM `tbl_leveranciers` WHERE ( `tbl_leveranciers`.`Uithangbord` = 'alphadent' ) as you see without using the schema name Which driver? Does somebody know an issue for this, too? Thanks Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OO database sort problem
Frank , Mechtilde I suppose Robby is pointing to the use of the filterering who have a bug when making a filter with the GUI OO produce SQL a statement like SELECT * FROM pmgdbase.tbl_leveranciers WHERE ( pmgdbase.tbl_leveranciers.Uithangbord = 'alphadent' ) This gives a error because pmgdbase.tbl_leveranciers, must been pmgdbase.tbl_leveranciers Same behavior when using the filter in a form I filled already a related Issue http://qa.openoffice.org/issues/show_bug.cgi?id=102793 for it Fernand Hi Robby, I have been an OO user for years and mostly love your package, however I recently ran up against the sort bug in OO 3.1.0 Base. Excuse my ignorance, but what exactly is the sort bug in OO 3.1.0 Base? Thanks Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] MySql-Connector 30-times slower than ODBC
We did some tests with the latest MySql-connector Alpha2 on Windows and found that in a real live situation that opening a table with 28.000 records takes 35 seconds before the whole table is loaded in memory.( going to the last record) With a ODBC connection it takes 1 second. Are we doing something wrong with our native connection or can this behavior been confirmed ? Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How can I store the default values and column descriptions in odb file?
hallo Michael , In the past i did some test with a odb file connected to a MS SQL server over ODBC. When I changed column widths and then saved the ODB file, and after reopening the formating is remembered. BUT it is still a mistery for me where this info is stored :-) Fernand Hi Ocke, still couldn´t find the solution to get the column default values and column descriptions working. We have two default values 1. DefaultValue and 2. ControlDefault The 2nd is stored inside the odb file db:default-value. The 1st is stored inside the database. The problem now was to get the default value from the database when moving to the insert row. This wasn't possible, here ControlDefault was invited. So when you use the table designer to create a table you always insert the ControlDefault. To change for example the wizard you have to set the DefaultValue at the column descriptor. The source code for the table designer can be found in dbaccess/source/ui/tabledesign I would like to store default values and the column descriptions in the odb files as we do not fully support them in the database. Is it right that base can do this for us or must the driver implement the functionality to store the values in the odb files? I have neither an idea how to tell base to do this for me nor how to do it my self in the driver :( At the moment the default values and the column descriptions can be set, but they are lost as soon as you close the connection. This is because the corresponding properties of the drivers column objects are set correctly, but there is no code in the driver to save/restore them to/from the odb. Best regards, Micha - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How can I store the default values and column descriptions in odb file?
Michael Strobel wrote: Hi Fernand, That the behavior I´m expecting, but since the default values and column descriptions are not saved to the odb file, I assume there is something missing in our driver, but I have no idea what it is. Maybe the ControlDefault has to be set to the DefaultValue when the DetaultValue property of a column object is changed. On the other hand I didn´t see anything like that in the code of the other drivers in the connectivity module. The same saving to odb problem appears when I try to change the column formatting in the table designer when using our driver, but there is a workaround for this. The column formatting is changed correctly when I open a table, then rightclick on the column heading and use the formatting option from this context menu. This way to get it saved to the odb, OK so far so good but where the hell is this information saved ? in my case (MSSQL-ODBC) when xraying I find all tables correctly named but : thiscomponent.tables.getbyindex(1).columns gives me a EMPTY object ? greetz fernand but it is not saved to the odb when it is changed in the table designer. Best regards, Micha -Original Message- From: Fernand Vanrie [mailto:s...@pmgroup.be] Sent: Mittwoch, 10. Juni 2009 09:40 To: dev@dba.openoffice.org Subject: Re: [dba-dev] How can I store the default values and column descriptions in odb file? hallo Michael , In the past i did some test with a odb file connected to a MS SQL server over ODBC. When I changed column widths and then saved the ODB file, and after reopening the formating is remembered. BUT it is still a mistery for me where this info is stored :-) Fernand Hi Ocke, still couldn´t find the solution to get the column default values and column descriptions working. We have two default values 1. DefaultValue and 2. ControlDefault The 2nd is stored inside the odb file db:default-value. The 1st is stored inside the database. The problem now was to get the default value from the database when moving to the insert row. This wasn't possible, here ControlDefault was invited. So when you use the table designer to create a table you always insert the ControlDefault. To change for example the wizard you have to set the DefaultValue at the column descriptor. The source code for the table designer can be found in dbaccess/source/ui/tabledesign I would like to store default values and the column descriptions in the odb files as we do not fully support them in the database. Is it right that base can do this for us or must the driver implement the functionality to store the values in the odb files? I have neither an idea how to tell base to do this for me nor how to do it my self in the driver :( At the moment the default values and the column descriptions can be set, but they are lost as soon as you close the connection. This is because the corresponding properties of the drivers column objects are set correctly, but there is no code in the driver to save/restore them to/from the odb. Best regards, Micha - 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How can I store the default values and column descriptions in odb file?
sorry: must been thiscomponent.datasource.tables.getbyindex(1).columns gives a EMPTY object Hi Fernand, That the behavior I´m expecting, but since the default values and column descriptions are not saved to the odb file, I assume there is something missing in our driver, but I have no idea what it is. Maybe the ControlDefault has to be set to the DefaultValue when the DetaultValue property of a column object is changed. On the other hand I didn´t see anything like that in the code of the other drivers in the connectivity module. The same saving to odb problem appears when I try to change the column formatting in the table designer when using our driver, but there is a workaround for this. The column formatting is changed correctly when I open a table, then rightclick on the column heading and use the formatting option from this context menu. This way to get it saved to the odb, OK so far so good but where the hell is this information saved ? in my case (MSSQL-ODBC) when xraying I find all tables correctly named but : thiscomponent.tables.getbyindex(1).columns gives me a EMPTY object ? greetz fernand but it is not saved to the odb when it is changed in the table designer. Best regards, Micha -Original Message- From: Fernand Vanrie [mailto:s...@pmgroup.be] Sent: Mittwoch, 10. Juni 2009 09:40 To: dev@dba.openoffice.org Subject: Re: [dba-dev] How can I store the default values and column descriptions in odb file? hallo Michael , In the past i did some test with a odb file connected to a MS SQL server over ODBC. When I changed column widths and then saved the ODB file, and after reopening the formating is remembered. BUT it is still a mistery for me where this info is stored :-) Fernand Hi Ocke, still couldn´t find the solution to get the column default values and column descriptions working. We have two default values 1. DefaultValue and 2. ControlDefault The 2nd is stored inside the odb file db:default-value. The 1st is stored inside the database. The problem now was to get the default value from the database when moving to the insert row. This wasn't possible, here ControlDefault was invited. So when you use the table designer to create a table you always insert the ControlDefault. To change for example the wizard you have to set the DefaultValue at the column descriptor. The source code for the table designer can be found in dbaccess/source/ui/tabledesign I would like to store default values and the column descriptions in the odb files as we do not fully support them in the database. Is it right that base can do this for us or must the driver implement the functionality to store the values in the odb files? I have neither an idea how to tell base to do this for me nor how to do it my self in the driver :( At the moment the default values and the column descriptions can be set, but they are lost as soon as you close the connection. This is because the corresponding properties of the drivers column objects are set correctly, but there is no code in the driver to save/restore them to/from the odb. Best regards, Micha - 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 - 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
Re: [dba-dev] Open database document from beamer - Bad Beamer.
Drew, Strange, i used the same Windows XP configuration, and the latest 3.1 snapshot (m8) I will trye on other machines here maybe it is my machine ? or the amount of memory. I comeback with more results Greetz Fernand Drew Jensen wrote: Fernand Vanrie wrote: Drew , Could this story been related to my latest issue http://qa.openoffice.org/issues/show_bug.cgi?id=100764 (100764) where i found that when selecting some lines in a beamer the events on a opened dialog no longer works, but calling the same macro from a toolbar works ? Hi Fernand, Just to let you know - I tried to confirm the issue, using your attached documents with 3.1 RC1 / Windows XP and could not reproduce the problem. Anyway - I'll try again using Ubuntu later tonight and update the issue afterwards, either way. 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
Re: [dba-dev] Form Tablecontrol event: how to obtain column, row and other information
Karl Weber wrote: Hi, I hope, this is the proper list. we have the same problem and developed kind of a work around - we know when a row or a column is selected if ubound(eventt.source.selection) = 0 - we uses the right cursor click for avoiding accidental clicks (when selecting a row)eventt.buttons = 2 - if you are courragious :-) then you can put a listener on the mouse itself and via the mouse postion find out with column is needed. We did this sucesfull in the past with OO-dialogs, but i am not sure if this will work in Forms Hope it helps Fernand I have a tablecontrol in a form and I can assign macros/scripts to various events. I already noticed, that one can also assign macros to events of columns, but this doesn't seem to work. (OOo 3.0) There should be an open issue about this problem. So for the moment I have to live with events -- e.g. mouse pressed -- fired from the tablecontrol as a whole. When this event is fired, I need to know a couple of things I don't know how to find out. Maybe someone can help me: (1) Was the mouse pressed in a particular cell, and if so, which one? (2) Was the mouse pressed on a column header, and if so, which column? (3) Was the mouse pressed on a row marker, and if so, which row? (4) Was the mouse pressed outside of header, row markers and cells? (5) How can I find out, which rows are selected, if any? (6) When I press the right mouse button in a cell or on a column header, a pop-up menu appears. Can I add my own menu items to these menus, and if so, how? Lot's of questions, but any help is very wellcome! (Pointers to documentation may suffice, if there is any. I didn't find any help in the DevGuide. ) Thanks in advance, -Karl - 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
Re: [dba-dev] Events on Form TableControl-elements not working
Frank I filled a issue and assigned to fs greetz Fernand Schönheit - Sun Microsystems Germany wrote: Hi Fernand, I tried to put a Mouse Click event on a Textfield (column) in a TableControl ioff aForm. The event is ignored and the macro on the event is not called Puting the Mouse Click Event on the TableControl itself works properly For the moment I found a work around using the properties of the row who is selected by the mouse click. Is this normal behaviour or do I mis something? Neither nor. I'd call it a bug. (Knowing the internals, I suppose this never worked.) Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Events on Form TableControl-elements not working
Hallo, I tried to put a Mouse Click event on a Textfield (column) in a TableControl ioff aForm. The event is ignored and the macro on the event is not called Puting the Mouse Click Event on the TableControl itself works properly For the moment I found a work around using the properties of the row who is selected by the mouse click. Is this normal behaviour or do I mis something? Thanks Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Dev m39 and SRB from qa-upload
Drew, Zoltan the DEV300m39 instals wronly as 3.0 and not as 3.1 there is already an issue for it greetz fernand Jensen wrote: Reizinger Zoltán wrote: I answers to my mail Dev300m39 win version installs as dev 3.0 instead of dev 3.1. http://www.openoffice.org/issues/show_bug.cgi?id=98168 Zoltan Hi All, I downloaded from mirror windows version of DEV300m39, and installed on freshly installed winXP noearlier version of DevOOo was installed. I tried to add SRB from qa-upload 2008.12.18 version and get error: The extension cannot be installed ... system dependencies are not fulfilled: OpenOffice.org 3.1. How can I install SRB? I will submit an issue. Zoltan Hi Zoltan, Don't know if you have already done this - but just in case. You can get DEV300_m39 to accept the SRB 1.1.0.xxx from the qa_upload site by: Open in archive tool, open for edit the file description.xml and change dependencies OpenOffice.org-minimal-version value=3.1 d:name=OpenOffice.org 3.1/ /dependencies to dependencies OpenOffice.org-minimal-version value=3.0 d:name=OpenOffice.org 3.0/ /dependencies update the oxt file with the changes and install it under m39. No doubt this voids the warranty ;/ 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] Shapes have no editable text in SRB
Ocke, In the 1.05 SRB, shapes have not the same text-edit functionality as is a normal Writter Doc.Its simply not possible to enter a text in a shape. As I see it shapes are a way to have some text-design features in SRB. When used on Company level (Text having some standards) then the use of Styles becomes also a issue . Are there plans to implement more text functionality in SBR and where can i find a specification off where we go with SBR, to avoid to ask for things who are already planned :-) Hope it helps Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Andrew , Thanks for your extented reply, I know to make allias field names and yes thats the problem now the SBR works also with my query:. However is this a bug ? or is it a rule that we need capitalised FIELD NAMES ? Greetz Fernand On Fri, Jan 16, 2009 at 11:22 AM, Fernand Vanrie s...@pmgroup.be wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Hello Fernand, From your description I would suspect that the problem is with your column names in the result set. Try opening your query and ensure that you have created aliases for any returned column that uses a function. ie. SELECT AVERGE( FIELD ), COUNT( FIELD) FROM TABLE GROUP BY FIELD Instead try: SELECT AVERGE( FIELD ) AS AVG , COUNT( FIELD) AS CNT FROM TABLE GROUP BY FIELD Of course using the Query Designer you do this by adding the Alias in the cell just below the field selection. I would be surprised if this does not clear up your problems. HTH Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) Best regards, Ocke Greezt Fernand - 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] SRB not working with Queries
I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] ReportBuilder do not build with MSQL TimeStamp fields
Do not kwow if this is the right place but: When using a ODBC connection to a MSQL server the Report Builder refuse to build the repport when a TimeStamp field is present in a Table. . When using a Query then it fails when the query is made and saved with the designer, when using native SQLmode then the report is build but there is no data in the printed timestamp fields. BTW: a CONVERT(varchar, mytimestampfiield, 103) is a tempory :-) workaround greetz Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to keep users away from Tabels ?
Drew, Good:: you are back :-) Thanks for this listeners stuff, they seems to even more tricky than i already supposed. As you can see I am still strugling to keep the users away from Tabels ect... Sinds Frank told me that passing alien connections to base-sub-components is not a good idea, do you have other , better ideas?? BTW: do you still work on you Report Runner extension, ? Greetz Fernand Hello Fernand, The functionality supplied with issue 97889 is available in the current development build of OO.o 3.1 (DEV300_m37 with m39 do out in a few days according to an email in lists today's), available now from the main OO.o website: http://download.openoffice.org select Development build from the right hand menu. This DEV300 package will install right along side of your current 3.0 released package without requiring any special accommodations. For an example of setting an event listener using OOBasic you could look at this entry: http://user.services.openoffice.org/en/forum/viewtopic.php?f=21t=10123 The example in this case shows setting a handler for the OpenDocument event on an ODS file - their is no real difference for doing this to an ODB file under the 3.1 development build, AFAIK. 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
Re: [dba-dev] How to keep users away from Tabels ?
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, I need now a 100% save way to close the base-doc when clossing the last Report or Form otherwise the Hidden-doc or Invisible-frame stay opens forever., I think to link a smaal macro ( Form-doc.parent.dispose) to the closing event of the last form. If you have control over the opened forms/reports (I understand you do), then you can add as css.lang.XEventListener to all those components, and keep track of them yourself. Alternatively, would fixing issue 97889 help you with this? O :-) you did it last Friday !! thanks a lot CWS dba31h any idea when i will be available for us ? Thanks Fernand Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] How to keep users away from Tabels ?
Hallo all, I am still strugling to find a way to uses a Base-doc as a frontend to a Datbase, wath include that a general usermay run querys, reports and Forms but mustkeep away from the Tables Now Frank S. Told me not to use alien links i have a closer look at the ReportRunner extension made by Drew Jensen. With just changing ReportDocuments to FormDocuments or combining the two this extension can been used to solve my problem. Drew maded the opened Base-doc-frame invisble but I found that opening in hidden mode works alsoo. I need now a 100% save way to close the base-doc when clossing the last Report or Form otherwise the Hidden-doc or Invisible-frame stay opens forever., I think to link a smaal macro ( Form-doc.parent.dispose) to the closing event of the last form. Any other ideas ? Greetz Fernand - 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?
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 when the form is being loaded, after that, any change to it is vetoed, since the assumption is that the form, living in the database document, always uses the connection which the main database window already established. Am I right posing that I must open all my forms with OpenFromURL and then passing this connection to the embedded subforms ? or have you a other trick ? Greetz and a succes full and Happy New Year to you and your Family Fernand Drew Jensen wrote: 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 - 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?
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 statements, ,how can i define the second connection tables in the SQL statement ? 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) Drew Jensen wrote: 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 - 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?
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: 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
Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
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 Fernand Drew Jensen wrote: 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 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. Hi Frank, Very good, and it does at first seem to fit the bill. If it actually does however, depends in the end on the goal one is after. My goal was best stated with the line All this so that your users are kept away from the raw tables, queries and such. Let me try to refine the goal first. - Use Base as a runtime platform for a data centric business process application - A bit better, and I think good enough for the moment. One comment on this, notice that nothing in this statement refers to the database engine used, embedded HSQL, local dBase files or remote MySQL / PostgreSQL / DB2, it doesn't matter. In fact if there were this open a form when opening the DB doc (I'll call it the autorun property for the moment) for ODB files then your suggestion of using a minimalist autorun form that turns around and loads the switchboard form sounds like a very good 'best practices' design pattern at the very least. However it doesn't fully meet my goal - because, if the macro security settings will not allow embedded scripts to run, leaving the autorun form open and the Base file open on the desktop the user can just close the autorun form and have access to the underlying functions. Not what I want to happen. 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 ) The property would have a default of NO. It would only be active for edit if the autorun property held the name of a form and when set to TRUE it changes the load behavior for the ODB file to: if autorun ---if hide_base_window = TRUE --open odb file with property HIDDEN = TRUE Ok - there are few things to think about here. Such as closing the ODB file. It would be really nice if Base had a feature that counted how many child windows where open IF hide_base_window = TRUE, incrementing this counter every time a window was opened and decrementing when one closed. When the counter hits 0, close the parent file - or something similar, it would take a bit more thought to get that right no doubt. Anyway - just a little idea to kick around on the list. Till later, 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
Re: [dba-dev] How to store formated text in OO base
Hi marc, Marc Santhoff wrote: Am Donnerstag, den 28.08.2008, 18:39 +0200 schrieb Fernand Vanrie: Marc Santhoff wrote: Am Montag, den 25.08.2008, 16:47 +0200 schrieb Fernand Vanrie: don't know if this is shorter, but as I said you can store your OO_source.odf into a stream and then read/write a blob field of your database. OK, I was concerned about the size of the blob's i will test it and comback with the results and nobody seems to now ( on the forum at least) how to get the stored binary data out of a database field !! I think this could be caused by: http://extensions.openoffice.org/issues/show_bug.cgi?id=83449 I don't know if the forum message is old enough, but nowadays (2.4.x) Thanks i hope it will been properly documented somwhere so no longer need off private:stream argument ? and 'args1(2).Name = DocumentBaseURL 'args1(2).Value = file:///h:/test.html is of no uses ? See the macro attached to the issue, it has any answers needed. But there is still a problem with this styreams, Just the Retrieving of a stream from a medium complex writerdoc (2 pages) takes over 20 seconds from a OO-database doc!! Storing the stream (after a time consuming loading from the datbase) to a tmpURL is prety fast but very space consuming on the database site Did you use a file on disk for streaming *to* the database? If you Yep, i isolate the needed textportion, put in a hidden doc , save and load the stream from the newly saved doc file. This is acetable slowly, but retrieving the stored steream from the datbase is the most time consuming thing ! As i am not a prof coder , i looked around for getting a stream out off the clipboard or out off a Xtransferable object but no luckso far For iamges we can get a stream from the internal storage oPictures.getByName(mFiles(j)).getInputStream()) and then to store them directly in a doc i found this code : REM Author: Stephan Wunderlich. Two lines added by ms777 and completed by Fernand Dim oShape Dim oProvider 'GraphicProvider service. oShape = oDoc.createInstance(com.sun.star.drawing.GraphicObjectShape) oGraphic = oDoc.createInstance(com.sun.star.text.GraphicObject) oDoc.getDrawPage().add(oShape) oProvider = createUnoService(com.sun.star.graphic.GraphicProvider) Dim oProps(0) as new com.sun.star.beans.PropertyValue oProps(0).Name = InputStream oProps(0).Value = oStream ' oProps(0).Name = URL ' oProps(0).Value = sGraphicURL oShape.Graphic = oProvider.queryGraphic(oProps()) oGraphic.GraphicUrl = oShape.GraphicUrl ' Insert at the current cursor location oDOc.text.insertTextContent(oDoc.getCurrentController().getViewCursor(), oGraphic, false) Maybe there is a more clever brain around who can get a stream out off the clibboard o a Xtranferable object ?? Thanks for your interest in this problem Fernand managed to get anything else working I'd be keen to see some code. ;) I stay with my RTF or even HTML coded strings, far more simple more speedy , and very economic in space :-) Seems to be [a|the] sensible solution currently. Regards, Marc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
Marc and Peter, Thanks for your responses, Normally for copying images and formated text portions from OO- docs or non-OO documents I simply uses the uno:copy with the dispatcher. This approach works fine I will now investigate the XTransferable stuff for a suposed more cleaner code :-). But I still has some questions: - how do i Store Cliboard or XTransferable content in to the database ? - how do i call it back from the base into the clibboard or in to a XTransferable object ? When having the database content in the cliboard or a in a XTransferable object, then the missing off a proper Form Field can been resolved with showing the database content in a frame or Cell. and using a writerdoc as a form. Thanks already for your help Fernand Peter Eberlein wrote: Peter Eberlein schrieb: Hi, Marc Santhoff schrieb: Am Freitag, den 22.08.2008, 13:44 +0200 schrieb Fernand Vanrie: Can hard coded or styled formated text out off a writer doc been stored in OO base and then been used to be placed in a new writerdoc. - witch data type ? - how to enter ? - how to reproduce in a form ? just tried to put the XTransferable in a formatted TextField without success. The field doesn't support clipboard or transferable actions with formatted text. Worth an RFE? Sub Main xCurrentController = ThisComponent.CurrentController xCursor = ThisComponent.getText.createTextCursor() xCursor.gotoEnd(true) xViewCursor = xCurrentController.getViewCursor // make the selection xViewCursor.gotoRange(xCursor,false) xTransferable = xCurrentController.getTransferable xTextField = Thiscomponent.DrawPage.Forms(0).getByName(TextBox) xView = xCurrentcontroller.getControl(xTextField) xView.setFocus // pasting xCurrentController.insertTransferable(xTransferable) End Sub - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] How to store formated text in OO base
OK I found a complex :-) solution using temp RTF files, but should works select the formated text portion and put it in a new empty OO_source.odf. save OO_source.odf to RTF_temp.rtf usng the RTF-Export Filter Read with simpleFileAcces the content of RTF_source.rtf and put it in a simple Varchar database field. Put the content of f the VarChar field into a simple text file with rtf extension insert the text.rtf into the OO- doc using the RTF- ImportFilter any ideas for shortening this process ? Thanks anyway Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Image control aspect ratio
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, A related question: Can you give me some hints to produce a minimal code (maybe no code at all :-) )to put images out of a database into a writerdoc who is the base document to run a mailmerge using the beamer(F4) In general, the database column is able to provide its content as stream (getBinaryStream, being an XInputStream). Of course you could write this to a file (though I do not know the API for this). Whether it's possible to directly put the binary content into a text doc - not sure, perhaps the css.graphic API has something for it. I suggest asking this in detail in [EMAIL PROTECTED] If your main problem is how to get the column which supplies the binary stream, then I might be able to help - if you tell me somewhat more about your setup. Frank, thanks for the reply but in the mean time we decided to store the URL's in the datbase and not the dinary data. But storing formated text into a database field is a related problem, and Marc Santhof replied as follows: Use doc.StoreToUrl() using a stream as target and connect that stream object to the db field (on a prepared statement get/setBinaryStream() IIRC). I'm sure *Frank* can help with the details of connecting a stream to a database column ... Can you help me Frank :-) Greetz Fernand Ciao Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] How to store formated text in OO base
Can hard coded or styled formated text out off a writer doc been stored in OO base and then been used to be placed in a new writerdoc. - witch data type ? - how to enter ? - how to reproduce in a form ? thanks for any hint Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] SRB version 1.0.2 is now live
Ocke Janssen - Sun Microsystems Inc. wrote: Hi, Fine but on my Windows machine neither update or new instalation (after deleting the( 1.01 do not works even after closing the Quickstarter :-) the instalations hangs after 2 bars on the evoluation bar Any kwown isues ?? for all who don't read the users list. The new version of the SRB is now available. Best regards, Ocke - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] SRB version 1.0.2 is now live
Reizinger Zoltán wrote: Fernand Vanrie írta: Fine but on my Windows machine neither update or new instalation (after deleting the( 1.01 do not works even after closing the Quickstarter :-) the instalations hangs after 2 bars on the evoluation bar Any kwown isues ?? What version of OOo want to install SRB 1.0.2, it needs at least 2.3 version! I am on 2.3.1 with windows XPprofessional Zoltan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Report Problem
Palav, Sukhada IN BOM SL wrote: Hello, I am using OpenOffice 2.3.1 for interfacing it with our Oracle database through ODBC connectivity. I have established the connection and I can access the data. But when I try to create a report using Report Wizard, it is taking lot of time to create one. After I click on Finish, a report is not generated even after a long wait. I am unable to understand this problem. We need to generate reports from our database and edit them. So can you please help me with this issue? I have expierenced the same problems with big MS-sql based tables and i think it was the size of the tables who matters, therefore we uses for our reports a query from who we are sure there are (a (limited) results. Using the latest SUN-Report-Builder can maybe also solve your problems ( you can fine this extension under the OO-extensions on the OO website.) when instaled then uses creating a report in design view Hope it helps Waiting for your reply, Regards, - Sukhada Palav Ph. No. 022-67572246 PTD-EA3 Power Transmission Distribution Division Siemens Ltd. 130, Pandurang Budhkar Marg, Worli, Mumbai-400018 Important notice:This e-mail and any attachment thereto contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Why not a calculater field in a form
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, I wonder why there is not a sort of a calculator' field available in a form where this calculator can be bound at a data field in the table where the form is based on. It is a simple concept needed by common users who wants to add data to a external data-base table ( who's concept can not been altered by a common user). Some fields has to been calculated based on input from the user or the input is based on other fields off the form. I now it can been done with some lines of macro code but for common users its far more simple to formulate their calculations directly in the form field. Is this a missed feature, or wanted behavior ? A missing feature, finally. Of course it would be nice to have this, alas, there's no infrastructure at all for this, yet, so implementing it would be a hude task. Sorry, I am not a professional coder but we are not missing that match i think :-) if we (mis)-use a listbox an instead of sql statement we use OO-formulas refering to Form-fields and to Table-fields then we have a calculaed listbox no ? Thanks for the respons Fernand Ciao Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Why not a calculater field in a form
Hallo, I wonder why there is not a sort of a calculator' field available in a form where this calculator can be bound at a data field in the table where the form is based on. It is a simple concept needed by common users who wants to add data to a external data-base table ( who's concept can not been altered by a common user). Some fields has to been calculated based on input from the user or the input is based on other fields off the form. I now it can been done with some lines of macro code but for common users its far more simple to formulate their calculations directly in the form field. Is this a missed feature, or wanted behavior ? Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Placeholder Characters in Parameter Queries
Under the OO-help Parameter Queries i found a special remark: Parameter queries with placeholders (*, _) or special characters (for example, ?) are not possible. This statement is not entirely true : Placeholders works but the user has to uses the SQL-placeholders like % an _ so the help should be is more correctly: like : Parameter queries with the OO placeholders (*, ?) are not possible. Only SQL-placeholders (%, _) can been used should I fill a issue not only to correct this help statement but also to correct the behavior that OO-placeholders are not transfered to SQL-placeholders ? In the same help section i found a cryptic phrase who i not understood and i suppose many other common users :-) if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? thanks Fernand - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries
Mechtilde wrote: Hello Fernand Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: Parameter queries with placeholders (*, _) or special characters (for example, ?) are not possible. This statement is not entirely true : Placeholders works but the user has to uses the SQL-placeholders like % an _ so the help should be is more correctly: like : Parameter queries with the OO placeholders (*, ?) are not possible. Only SQL-placeholders (%, _) can been used should I fill a issue not only to correct this help statement but also to correct the behavior that OO-placeholders are not transfered to SQL-placeholders ? This would be very interesting, but I can't confirm it. Can you please create an example where you set a parameter query in which you can use a placeholder for selecting values from a column. make a ODBC conection to (MS) SQL server based data base I make a simple query in design mode the like:Userinput must been written without spaces that resulys in a SQL statement: SELECT firma FROM Agentschappen.dbo.tbl_Klanten WHERE ( ( firma LIKE :UserInput ) ) when running the interface prompt for the Userinput and inputting a% results in the column content who started with a %a gives all results ended on a ect. greetz Fernand Regards Mechtilde - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Placeholder Characters in Parameter Queries II
Mechtilde wrote: Hello Fernand Vanrie schrieb: Under the OO-help Parameter Queries i found a special remark: snipp / In the same help section i found a cryptic phrase who i not understood and i suppose many other common users :-) if you formulate a parameter query and you save it with the variables, you can later create a query in which only the variables have to be replaced by the expressions that you want. OpenOffice.org asks for these variables in a dialog as soon as you open the query. Can someone explains me what thats means ? Can you explain more precise what do not understand? when its means that you can later create a query means you can RUN a query then is understand the lot :-) Regards Mechtilde - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Manupelating the Datasource of the Report Builder
Hallo, For making Reports acsesable for cummon users i need to make a macro with data-selection- criteria who produces a data-set who can be used a the source for a rpre-definned report build by the wizard or the Sun Report Builder. Can the source be altered by the macro and can data selected in the GUI- beamer been used? I can make a row-set out of selected data in the beamer Thanks for any hint - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Re: [Spam] Re: [dba-dev] Manupelating the Datasource of the Report Builder
Ocke Janssen wrote: Hello Fernand Vanrie, I attached a short basic macro which creates the report builder. After that you could change the command or other properties you like. Sadly you can't at the moment open it hidden. http://www.openoffice.org/issues/show_bug.cgi?id=85506 And issue for a better API where you should just call http://www.openoffice.org/issues/show_bug.cgi?id=85507 getReportDocuments().getByName(Report1).getComponent() I hope this helps a little bit. Ocke , thanks but your mailer has replaced the bas-fileswith this message The original attachment - report.bas - has been removed from this message, as it is a type of file which has recently been used to carry viruses and other malicious software. The following extensions are no longer supported as valid email attachments and will be removed since they are primarily used to carry viruses and other malicious software: asp bas bat chm cmd com exe hlp hta inf isp js jse lnk msi mst pcd pif reg scr url vbe vbs ws wsh sun.com.zip please send me the code in a other file ! thanks again Best regards, Ocke Fernand Vanrie wrote: Hallo, For making Reports acsesable for cummon users i need to make a macro with data-selection- criteria who produces a data-set who can be used a the source for a rpre-definned report build by the wizard or the Sun Report Builder. Can the source be altered by the macro and can data selected in the GUI- beamer been used? I can make a row-set out of selected data in the beamer Thanks for any hint - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]