Re: [dba-dev] Changes to DB are not persistent
Hi Daniel, How about using commit() or setting up the connection instance as autoCommit ? http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#commit http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#setAutoCommit Alex - 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
Hi Ocke, - "Ocke Janssen" a écrit : > PS: We found an issue with select * from table where "id" in ( > 'll',OO') > The only way I can get this to run in that latest downloaded version is by removing the single quotes around the values. Alex - 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
Hi Ocke, all, - "Peter Eberlein" a écrit : Tested the download on Mac OSX SnowLeopard. Seems to work fine for me with the Mysql connector 1.0.0. Alex P.S. One gripe that I do have is that although this installation overwrote my previous OOo user settings, it did not pick up the already installed extensions. Alex - 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
> 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 Excellent, great news, thanks :-) Alex - 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
Hi Ocke, - "Ocke Janssen" a écrit : > > As I mentioned, CAST works for me with OOo 3.2.1. It also works for > me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that > is based on). > One more interesting thing > when executing > select CAST('2001-01-01' as DATE) > works, but when executing > select CAST('2001-01-01' as DATE) from ´testdb´.´i115436´ > an error is thrown. You need to create an alias for the CASTed field. If you use this statement instead, it should work : SELECT CAST('2001-01-01' as DATE) as 'MyDate' from 'testdb'.'i115436' > > Could you please add some sample data to the issue? > If I get a bit of time today, I'll add some sample data to the issue. Alex - 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
> > I'm going to test my actual setup with the latest OOoRC, if I can get > it to install nicely beside my current OOo 3.2.1 on MacOSX. > More info : I have just tested with OOo 3.3rc7, same connector, same mysql server, and CAST still functions correctly for me. So my guess is that if there is a problem, it is related to latest version of mysql server, which is 5.1.53, so the won't fix is understandable because apparently it is not OOo's bug. Alex - 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
Hi Ocke, - "Ocke Janssen" a écrit : > 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. As I mentioned, CAST works for me with OOo 3.2.1. It also works for me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that is based on). > > Did anyone did an upgrade to a newer MySQL version before the > statement > stop working? > My actual version of mysql server is : Server version: 5.1.50 MySQL Community Server (GPL) My actual version of the mysql connector extension is : 1.0.0 I'm going to test my actual setup with the latest OOoRC, if I can get it to install nicely beside my current OOo 3.2.1 on MacOSX. Alex - 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
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 Vanrie" 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 Vanrie" 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
Re: [dba-dev] Re: CAST() no longer working with OOO 330m16
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 Vanrie" 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
Re: [dba-dev] How to set a MySQL TIMESTAMP to null
Hi Fernand, > 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 > 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] LDAP mulit-valued address field
Hi Lars, > Is there an LDAP driver in oo to address and fix this issue? Or is > this > possibly a known issue (I could not find any infos on the web)? If > so, > is there possibly a work around? > AFAIK, OOo doesn't support multivalued fields, irrespective of the driver used. I could be wrong, but each time I have tried to use multivalued fields in OOo, be it via JDBC, ODBC or native connectors, the attempts have failed and only the first value (if any at all) is retrieved. Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ODBC from AS/400, results dependent on server version
Hi, > Querying the V5R3 server, I see the expected results from the V5R3 > server in both both Base (direct entry of SQL) and Calc (the Data > Source Browser and the spreadsheet). However, from the V5R2 server, > the three columns derived with char() show no useful information: in > the result of direct entry of SQL in Base and in the Data Source > Browser they show "", and in the spreadsheet they show "#N/A" Can't answer your question with respect to AS400 stuff, but in my experience with MySQL dbs, items shown in the DSB or SQL query results often come from either Base's incapability to deal with the data object it is being presented by the driver or a problem with the driver itself and the data it is getting from the server. > > I wonder if this behaviour is right. And if it is wrong, does anybody > care, given the age of V5R2? V6R1 of the o/s has been in production > for a couple of years, and V7R1 is anticipated shortly. In short, is > this a candidate for a bug report? The question for me would be whether the problem still exists in V6R1 ? Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] postgres-sdbc for mac os x
Hi Christoph, > Hi, > > I am looking for a way to use the postgres-sdbc module on darwin/mac > > os x (if it supports kerberos authentication, which I assume since it > > is using the postgresql client library, right?). However the packages > > on http://dba.openoffice.org/drivers/postgresql/index.html don't seem > > to contain drivers for this platform. > I seem to recall that getting this to run on Mac was a PITA. I tried integrating compilation of the driver into my Mac OO build, but it still wouldn't work at the time (nearly 2 years ago now). In the end, I switched to the JDBC driver that you can download and install from the internet as a prepackaged image file and that worked fine (mostly). Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Please welcome the newest member of the Base QA Team - Zoltan Reizinger
Congrats to both Drew and Zoltan in their respective new/continued roles ! Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Re: [dba-features] new/DEV300m42 : SRB ReportWizard supports binary field types
lars.langh...@sun.com a écrit : Hi Lars, > *Description* > - > It is possible to select BINARY, VARBINARY, LONGVARBINARY datatypes in > the Report Wizard. This will insert ImageControls instead of formatted > fields. The images will be set 4cm high. Pictures will scale down to > this size. > > Good news !!! I take it the control can be resized ? Alex - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
RE: [dba-dev] OpenDocument event assigned macro can not execute - now what?
Errrm, logically, it shouldn't run the macros. Ideally, you would get a message telling you that macros have been deactivated or that you don't have the rights to run MyMacro etc, but wait, let me guess, OOo just crashes without warning ? Or better still, it runs the macros regardless ? ;-) Alex - Message d'origine - De: Drew Jensen Env: vendredi 12 décembre 2008 00:10 À: dev@dba.openoffice.org Objet: [dba-dev] OpenDocument event assigned macro can not execute - now what? Here is the scenario - You have downloaded OpenOffice.org 3.1. You installed the Switchboard extension. You created a Base database file setting. Developed your embedded scripts to handle the business logic in your database. Used Switchboard to generate your opening screen. Carefully crafted your forums so that when ever a user level form is closed the switchboard form is again opened. Set the Switchboard form to close the database file when it is closed. All this so that your users are kept away from the raw tables, queries and such. Now - the user goes and disables macro execution - or loads the file from a directory that does not allow embedded macros to run. What should happen? Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] 64-bit version of the PostgreSQL SDBC driver ? Pretty please ?
Emmanuel Charpentier a écrit : Hi, I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I currently use a new laptop with an Intel Core2 Duo. Consequently, I installed Ubuntu Hardy amd64. This distribution has a openoffice.org-sdbc-postgresql package, which is 0.7.5, and no update yet to 0.7.6. I asked a similar question about a version for the Mac Intel platform, when he announced the availability of the new version, but as yet have had no reply from the original developer. That said, he might be on vacation. :-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] postgresql-sdbc-0.7.6
Joerg Budischewski a écrit : Hi Joerg, I'd like to announce the availability of the version 0.7.6 of the native postgresql driver for OpenOffice.org for windows and linux x86. What would it need to get it to work with Mac OSX (assuming that is at all possible) ? I have a Tiger OSX OOo Aqua build environment, Python 2.5.1 Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: Sun Report Builder with EuroOffice Map Chart extension
Ocke Janssen a écrit : I am a developer from MultiRacio Ltd., responsible for the "EuroOffice" brand of extensions. Seeing how useful and popular Sun Report Builder is, we had the idea of bringing the functionality of EuroOffice Map Chart to it. It would allow adding automatically generated map charts to your reports. To read about EuroOffice Map Chart here is its page in the Extension Repository: http://extensions.services.openoffice.org/project/eurooffice-mapchart We now have a prototype of this integration working. That sounds really cool. :-) Well a client already asked me whether I couldn't already do this for him, i.e. send him reports with maps of the country against each tuple. And there was I planning to build a macro run db table for storing and retrieving vectorised map outlines of the different states ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Re: [dba-users] OOo QA - database confirm issues & beyond irc
Christoph Lukasiak a écrit : Hi Chris, Unfortunately I shall be out of the office on travel all of that week, so I can't count myself in this time. :-( Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Failures saving data to MySQL tables from OOo form
Bob Kline a écrit : Hi Bob, I'm having a number of problems with getting OpenOffice's Base to do the right thing with this table, but the most frustrating is that when I create a form based on the table, then go to insert a new row using that form, I get an error message complaining that the Amount column cannot be NULL, even though I'm entering a value for that column. This problem is occurring regardless of OOo version or client platform (e.g., OOo 2.3 on Ubuntu Gutsy, or OOo 2.0 on Windows NT). I'm telling OOo that the database is MySQL and I'm connecting over ODBC. So the problem might lie with the ODBC driver version :-) You don't tell us which one you are using, and it does make a difference. I have not found an ODBC driver version provided by MySQL thus far that does not have some form of functional limitation when working with OOo. I can only hope that things will improve now that both products have developers under the same mothership roof :-)) Additionally, the Ubuntu versions of OOo are notoriously buggy, and unfortunately I have found that most of my problems have occurred when using the Base module (although there are quite a few in the Writer module too). I can't speak for the Windows versions per se, but the 2.0 version was also notoriously buggy in certain key areas of Base. The other problems might be clues to what's causing the first problem, or they may be unrelated (by improbable coincidence). In the 2.3 OOo on Ubuntu, when I invoke the form wizard, the list of fields offered for inclusion on the form omits the Amount column (but the form wizard in OOo 2.0 on WinNT includes it). Also, both installations show the Amount column as "Text (fix) [ char ]" when I bring up Edit on the table definition, and trying to correct that doesn't stick (next time I open the Editing windows on the table definition, my Decimal 10, 2 is gone, and it's back to "Text (fix) [ char ]"). Is this a known bug (or bugs)? I seem to recall that this is a known MySQL ODBC driver bug and incompatibilty between server version 5.0.x and the driver (datatype mapping problem). http://forum.ubuntu-fr.org/viewtopic.php?pid=1438002 http://bugs.mysql.com/bug.php?id=11795 http://bugs.mysql.com/bug.php?id=11035 If not, I'll be happy to help track it down with whatever sleuthing I can perform on my end. I have addressed my own needs satisfactorily by moving the data into PostgreSQL, with which OOo does not appear to have the problems described above Even postgresql isn't perfect, but at least the bugs appear to be consistent across driver versions, and working with postgresql and OOo has improved greatly over the years. , so my interest in pursuing this just is to improve OOo. Since OOo works with PostgreSQL, and since I can successfully retrieve and manipulate the data in the MySQL table using the MySQL ODBC driver, I assume this is one of those problems which arises from defects in the way the two packages (OOo base and the ODBC driver) interact with each other. Apparently, the solution is to use the latest MyODBC driver, well at least the 3.51.12 version. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: Base
Seale a écrit : Hi Seale, I just downloaded open office and just love it so far! I have been wanting one system that works for everything so I am so glad to have found you. I just bought an iMac in the last 4 months so I am trying to get up to speed on it, but its address book is just not very involved. So I don't know if it is a LAPD or not or how to find that out. The latest version of OOo for Mac includes Addressbook access from the db component, but I don't know whether you've got read/write access or just read access. Use the db creation wizard for this : File > New > Database, you should be able to select the Addressbook from the dropdown list of existing databases to connect to. I was originally wanting to ask you why there was not a contact management system with the other programs, but maybe it is Base. If it is, can you confirm and if it is not, do you have one in mind to create? I loved ECCO and then liked Outlook, but it was still not able to do everything I wanted. I have yet to read about Base because I was working with the two other programs, word processing and the spreadsheets. There is no PIM integrated into OOo, at least not yet. I don't know whether its on the cards for future development. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] AWT trees
Le Saturday 03 November 2007 21:22:48 Ariel Constenla-Haile, vous avez écrit : Hi Ariel, > Can I change the status from UNCONFIRMED to NEW? I think we simple users > can not do this, am I wrong? > > Well, this makes me think about what I did wrong with issue > > http://www.openoffice.org/issues/show_bug.cgi?id=81985 > > It's been a moth...and nothing. It's serious because it makes OOo crash!!! > This is the typical case where I had no idea to which component submit > the issue, and the issue tracker help didn't give me much advice on the > topic: as it is something that happens inside the IDE I thought... but > is also something with embedded objects ... and ... > I send error reports ... and ... also nothing happens... > Join the QA project and ask for "CAN CONFIRM" privileges, then you will be able to set and modify issues independently of the one's you create. One of the basic rules when confirming is to add the oooqa keyword in the keyword field. If the bug crashes OOo, then also add the "crash" keyword. The rules are explained somewhere in the QA project website pages. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: Off Topic question - Who owns tools.bas
On Wednesday 17 October 2007 07:29:31 Andrew Jensen wrote: Hi Drew, > Darn MSAccess export files with booleans ( 0,1) and text fields can > looks like: > > 2145,0,0,0,1,"Some text, and more text / all one field",0,0,2.15 > > That damned embedded comma..you know. Even better, this is a valid > export from MSA also: > > 2145,0,0,0,1,"Some text, and I"ll make more text / all one field",0,0,2.15 > > A typo during data entry no doubt, but MSA takes it and exports it just > like that...arrrgh > If its any consolation at all, FileMaker Pro allows the same behaviour, the same also occurs with line breaks, and date fields are even worse :-(( as I have found out to my cost when migrating. At present, I have found no way to get around this problem when trying to open CSV files into Calc and then import them into Base. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Database Recovery
On Thursday 30 August 2007 04:04:12 Barbara Duprey wrote: > Hi Barbara, Yes, I really, really want to go to 2.3, but the site is still > offering 2.2.1 as the latest stable release and I'm not sure a > development build is what I want. So I seem to have these choices: > stick with 2.0.4 until 2.3 comes out and then upgrade; upgrade to > 2.2.1 and then to 2.3 in a few(?) days; upgrade to the latest 2.3 > development build and then to 2.3 when it's stable. Are you saying > that the latest 2.3 development build really is stable enough for > production work? If so, I'll gladly go to it. I'm on WinXP, us-en, so > the more arcane aspects of locale and so on don't really affect me. If you, like many of us, use OOo in production and need to rely on data safety as much as is humanly possible with the current release, then upgrade to 2.2.1 and wait for 2.3 to be declared stable. I test the dev builds alongside the stable releases, simply because I, like you, can't afford to have production data mangled by an app, and because I have a pool of heterogeneous OS running OOo at work (Linux, Mac, FreeBSD and the occasional Windows). We mainly have Kubuntu workstations, and they use the Kubuntu package prepared by that dev group (with all its faults and bugs, some of them very annoying to me, but my staff seem to get by). My problem is not of having the latest whingdiz features, but having an office suite that is overall stable (i.e. every module we use at work) and doesn't lose or reformat your data in unexpected ways (to the extent that such is possible with any software program :-) ) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Database Recovery
On Wednesday 29 August 2007 15:53:22 Barbara Duprey wrote: Hi Barbara, > > When I was using the linked .dbf and this happened, I think it may be > why my data got so royally messed up. I suspect it was "recovering" by > using some data buffer it had hanging around, and with no primary key, I > believe it was pretty much random where the changes went (sometimes in a > different record but not even into the same field). Now, with the > properly defined embedded database, I haven't noticed any contamination > of existing data -- although I have had to (re)enter data I'd have sworn > was already there. But then, my memory needs external assists, too! This used to happen a lot in the 2.0 series, and often the best bet was simply to cancel the recovery process if you were sure that you hadn't entered any changes into your db. > > I REALLY want 2.3. I'll follow up on this then, if it happens again. In > the meantime, I'll cancel the recovery if there was no crash. Like Frank says, you really should upgrade to the latest 2.3, it really has become far stabler and more reliable (on the whole ;-) ) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Comments on Issue 80426
On Tuesday 21 August 2007 22:57:01 Frank Schönheit - Sun Microsystems Germany wrote: Hi Frank, > > What I suppose the submitter of the issue ran into (unfortunately his > description wasn't clear here) is a NOT NULL field with a server-side > default - in this case, OOo wants to force him to enter a value, > nonetheless. Possibly getting off topic here, so I'll tread carefully : Aha, so this is a problem with OOo, and one I might add, that has been around ever since I first started using OOo with mysql (about 6 years ago, now), in other words, ages :-( although I can't recall ever having seen this listed as an Issue :-) I've always found this behaviour extremely annoying, particularly with date and/or timestamp fields, since (1) it forces the user to enter data that shouldn't in fact be necessary (even if it is just a "space"), (2) forces the db developer into making a workaround to correct the wrongly entered data string and (3) makes it obligatory to display the field in an editable state on the form (which shouldn't actually be required at all). In some instances, this is possible with an SQL command in the table/field creation statement, in others, it requires macro trickery to catch the update of the bound field, which rather defeats the purpose of having NOT NULL DEFAULT values defined ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Updating from Query with Join
On Monday 20 August 2007 19:14:50 Barbara Duprey wrote: > One real problem, though -- I don't seem to be able to update from any > query with a join. The keys of both tables are in the data, and I'm only > trying to update in the Violations table. As long as I don't have a > join, no problem. Clicking the Edit Data icon doesn't help. Is this > behavior of read-only queries from joins WAD (Working As Designed) or is > there some way I can do my updates from there? IMO, no this isn't how it should work, the functionality should have been there in the first place, but...you can say that about a lot of things that didn't have the resources necessary for their development / integration in many of the OOo modules :-) > Any recommendations? Would updating to 2.2.x help? There is an issue : http://qa.openoffice.org/issues/show_bug.cgi?id=53377 Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Base Performance
On Thursday 28 June 2007 20:40:04 andrew wrote: Hi Drew, > Well, no. I am talking about using the search function. That is not SQL > based, instead it iterates over the result set looking for the first > match, and it is all on the client side. > > Here is a specific example. I have a table that consists of 21 fields, > all of type integer or double. The table has 10,000 records. This is a > HSQL embedded database, it is running under XP on an AMD 3300+ processor > and 640Meg Ram. The table has a primary key field of type integer, and > is fully packed ( meaning there are keys from 1 - 19,999 ). > > I open that table in a data view and place my cursor in the PK field. I > then open the search box ( click on the binoculars ) and enter a search > criteria of 2000. Now what would be an acceptable time for that search > to find a match - I'm not sure, but I am relatively sure that what I get > is not an acceptable time - on average 74 Seconds. Tell me about it :-( This problem has existed for as long as I can recall, irrespective of the db. I've had this with DBFs, mysql, HSQLDB, so the problem is definitely with OOo or the way that it executes the search function. The DBF that I used to use for my addressbook/contacts was originally created in Lotus Approach. I then migrated it to StarOffice and from there to OOo, so it's roughly about 10 years old. It hasn't been fed with data for a while because I switched to mysql about 5 years ago. We have a similar issue with another db in which the users are currently forced to filter their data in order to get acceptable performance, but as you said, this then forbids any browsing outside of the filtered resultset, which is something they could do with their previous db, a MacOS FileMaker Pro db. > > If I use the standard filter this time drops to under 2 seconds. That is > most assuredly acceptable, and yes that was done with SQL commands. The > problem is, this is a desktop database and many of the users want the > ability to browse the adjacent records after the search. In other words > they did not want to filter the result set at all, they wanted a search > function on the current result set. To add to the problem is the > behavior of removing the filter - the result set is reloaded and the > record pointer placed back to the first record. > If you're looking for performance data with HSQLDB, for example in copying from Calc to HSQLDB, you should search IssueTracker for stuff put up by Tony Galmiche who did some performance testing on early versions of OOo 2.0. I assume that these issues have either been marked as INVALID, RESOLVED or OOoLater due to resource constraints. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Base excruciatingly slow
On Thursday 21 June 2007 01:32:54 Martin d'Anjou wrote: Hi Martin, > > I started using OO Base with ODBC and MySQL. It was slow to the point of > being unusable, and I almost gave up. However, I found that if I use the > IP address of the database server rather than the hostname, things go much > faster. > I have always had this issue when attempting to access a MySQL server via the internet. Usually what happens is that a timeout situation is reached, which cause Base to hang. This situation was present even in the pre-Base versions of OOo, i.e. in the 1.x series. OOo seems to have problems caching hostnames, rather than IP addresses. If you know the IP address, I have found, as you did, that things work much better. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] No saving of form data when inserted into controls with api-commands
Le dimanche 20 mai 2007 00:MM, Marc Santhoff a écrit : Hi, > But I'd be very pleased if someone would take the task of making XML > snippet format out of the posting (Alex?). > I can certainly have a look, but I've never used the snippet creator as yet, probably for the same reasons as you ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] No saving of form data when inserted into controls with api-commands
Le vendredi 18 mai 2007 18:MM, Marc Santhoff a écrit : Marc, > > It's "Code-giving day" today. ;) You have saved me countless hours of trawling through the API, a huge thank you > > Please post any additions you make, not all possible cases are catched > by the code! > You're on !! Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] No saving of form data when inserted into controls with api-commands
Le mercredi 16 mai 2007 15:MM, Marc Santhoff a écrit : Hi, > Especially when using BASIC there is no way of converting datatyes using > an API service (at lest one I know, please tell me if so!) so you'd have > to convert each value to the type the bound fields wants to see. In > BASIC this blows up code by factor three (I know for sure, because I > have made some read- and write-back-macros for database data in calc > sheets :P ). Yep, code explosion :-( > > If one uses the control/view in this scenario the only types to detect > are Date-, Time- and FormattedField bindings, all the rest is text. The > conversion and format checking is done behind the scenes. And it is still a pain having to convert dates from strings and back :-( > > I used this approach for copying a record in a form as template for e > new one (excliding the primary key field). Now I have exactly this problem, you wouldn't have some macro code lying around somewhere that you'd be willing to share by any chance ? (he says grovelling ;-) ) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Confusion in MySql driver limitations Base 2.0.n
Le samedi 28 avril 2007 20:MM, [EMAIL PROTECTED] a écrit : Doh !!! Forget my last e-mail Mike, didn't look at the OP until after I sent it - of course, you are one and the same. Sorry :-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Confusion in MySql driver limitations Base 2.0.n
Hi Mike, > > But MySQL does support relationships, so is this error mal formed? > > Has this been solved and I'm doing something wrong in driver permissions? > Is there a workaround besides hard-coding updates by Macro or other? > Is there a solution planned in the future, if there is no present solution? > There is a very interesting thread ongoing here that talks about the associated problems of incomplete relations and RI support between OOo and MySQL. It might shed some light on your problem : http://www.oooforum.org/forum/viewtopic.phtml?t=56418 Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Project: Joins in dBase queries
Le vendredi 9 février 2007 01:MM, CPHennessy a écrit : Hi CPH, > If you would like to see a better system to manage our emails then please > contribute to http://www.openoffice.org/issues/show_bug.cgi?id=24325 (or if > you are in Sun management please be aware that we probably look like we are > silent on a significant percentage of emails on most mailing lists as the > original emailer does not see responses). And yes that bug report is open > several years !! This also applies to some of the pepole who work at Sun and who sometimes (systematically) use a special mail sender address from their internal mail system and to which we can not subscribe via the lists, making responses impossible. Fortunately, none of the Sun devs here do that, they always seem to be available, barring the usual absences such as births, moving house and vacation, thanks guys ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Project: Joins in dBase queries
Grzegorz Borys wrote: Hi, I'm junior software developer / programmer who decided to help OpenOffice. Right now I'm starting to go trough `Developers Guide` and in near future I would like to help with "Joins in dBase queries" Project. If it will be still available. If you can do this, you will receive much kudos from all of us still loving dBase (and I'm one of them :-) ). Good luck in your quest. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] MySQL and Open Office
posta uno wrote: Hi, I have to create a database system and I’d like to use Open Office insted of Microsoft Office. For my Db I will have a Server,(probably Linux running on server), and at least 10 Pc that must work in a network.They all will be linked to server. Same as in my office. I will install on each “client pc” MySQL Client whereas MySQL administrator will run on server. The mysql client is not actually necessary to get MySQL and OOo to talk to each other. Now the question is: Is it possible to use CALC program and/or BASE program with MySQL in this network? Yes, and if you care to look at the documentation project's web page, you should even be able to find full documentation on how to set it up. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Re: [dba-features] changed/680m177 : forms: date and time fields do not default to "Today" and "Now" anymore
[EMAIL PROTECTED] wrote: Hi Frank, In database forms, date and time fields 'til recently had the habit to default to "Today" (the date fields) and "Now" (the time fields). That is, when you had such a field in your form, and wanted to enter a new record, then the fields were pre-filled with the current date respectively time. This behaviour, which is almost never desired, has been changed - the fields are not pre-filled anymore. Great news - should stop the complaints fro my users ;-) Thanks, Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Display Image from database in ImageControl using a macro
Willem Ligtenberg wrote: I'm sorry, but the website and the mailinglist is no good for me. I have had French lessons in Highschool, but those were a few years ago... So I guess that searching the mailinglist will be no good. I have found the Base tutorial I think. Is it this one? http://fr.openoffice.org/files/documents/67/3465/ImageDansFormulaire.odt Well, I had 5 minutes or so, did the translation into English, and posted it here : http://fr.openoffice.org/files/documents/67/3477/ImageInForm.odt I've also attached it to the present mail, but it might get scrubbed by list server. Alex ImageInForm.odt Description: Binary data - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Display Image from database in ImageControl using a macro
Willem Ligtenberg wrote: Hi again, I'm sorry, but the website and the mailinglist is no good for me. I have had French lessons in Highschool, but those were a few years ago... So I guess that searching the mailinglist will be no good. I have found the Base tutorial I think. Is it this one? http://fr.openoffice.org/files/documents/67/3465/ImageDansFormulaire.odt Yes, that's the one. If you have trouble understanding it, I might get time to translate it into English sometime during the week. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Display Image from database in ImageControl using a macro
Willem Ligtenberg wrote: Hi WIllem, You just gave me the answer I needed. (That it is not possible) So I can go on ahead with my exploration for a good solution. You should take a look at the documentation section at http://fr.openoffice.org under the Base tutorials. I believe someone has written a little guide (mini-How-to) explaining how to display the images in the way that you want. There have also been discussions on the prog@fr.openoffice.org mailing list about how to do this programmatically to get them into a report. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Base and sucessive installs of OOo
Frank Schönheit - Sun Microsystems Germany wrote: Hi Frank, I'd call it a bug. A usability bug, at least. Well, yes, that reassures me somewhat ;-) Is there no way to stop this (mis)behaviour ? ... Surely, this feature ;-) can be turned off somehow ? Not that I know. Except filing an issue and wait for it being fixed :). OK. IssueTracker here I come... Thanks, Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] Base and sucessive installs of OOo
Hi all, There is a very annoying, hmmm, well, I suppose you could call it a feature, but I call it a bug ;-) when you install or upgrade OOo over a previous installation. This bug is that if you agree to having your data copied over (as do most sane people who've carried out personal configuration of their OOo environment), then the "copy over" routine automatically recreates ODB files corresponding to the datasources that were already declared. If these datasources already existed as ODB files, then the copies take the same name as the original and an incremented number is appended to the file name. All of these files get created in the user's home directory on a Linux box, and just keep on cluttering up the directory, especially since, once copied, they become utterly useless. Is there no way to stop this (mis)behaviour ? I checked one of my Linux boxes used for testing dev versions and stable versions of OOo (same user), and it had 15 different Cabinet*.odb files. Having to plough through the list to find which one was actually the one that functioned was particularly irksome and time wasting. It wouldn't be so bad if the user was told with a message which of his newly created copies would actually work. Surely, this feature ;-) can be turned off somehow ? Maybe an issue has been filed for this already ? Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] JavaDB/Derby & Base
Josh Berkus wrote: Hi Josh, "What would it take to get OOo to switch from HSQLDB to JavaDB?" Significant assistance from the Sun Derby team, including migration and tools, is not at all out of the question. So what are the reasons not to switch? What's the costs? Well that is what we would say in French is a "pavé dans la mare", or a "brick in the millpond" for wont of a better expression. Funnily enough, your very question was asked I guess about 18 months ago on this same list, but of course at the time Sun wasn't, or had only just, become involved in Derby/Apache (I don't remember the exact dates, just that someone on this list came up with that question). Not that I can speak for Frank, but personally this question comes as no surprise to me (and I doubt that it does to Frank either, it was just a matter of time before it came up). To be honest, I am neutral when it comes to selecting any particular Java based db solution, since I still believe that making OOo more and more Java dependent for what I consider to be core functionality is not the way to go, but that is a whole different discussion which we've had out here and elsewhere before, so I'll not go into that again ;-) The question is : does/can OOo support another Java based db all-in-one file solution, since that is what I believe Derby is alleged to be. If the resources are there, why not ? Personally, I'd rather see them allocated elsewhere (SQLite anybody ?, mysql all-in-one ?), but then hey, I still haven't been weened off MySQL yet ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] oOo et access - publipostage
Le samedi 12 novembre 2005 à 18:40 +0100, Coyote a écrit : Quick translation for those who don't "do" French ;-) > J'ai créé une appli sous access qui me permet de faire la gestion d'une > association et des publipostages. I've created an application using Access that lets me manage a club and mass mailing. > Je souhaite migrer vers oOo , malheureusement, je ne sais pas si Base me > permettra de faire tout ce que je fais dans Access 97. > I'd like to migrate this application to OOo, but unfortunately I don't know whether Base is capable of doing all that I currently do with Access 97. > je souhaite donc commencer par continuer d'utiliser access et au lieu de > lancer des documents word pour le publipostage, lancer des documents créés > avec Writer... mais comment faire ??? > I'd thus like to continue using Access and instead of starting Word for the mailing, start OOo Writer documents, but how ? > merci pour votre aide. > TIA, > -- > @+ Coyote > Note : Pour répondre par email, effacer le '_sup' de l'adresse. > To reply, delete sup from the address Alex > - > 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] oOo et access - publipostage
Le samedi 12 novembre 2005 à 18:40 +0100, Coyote a écrit : Bonsoir, Cette liste est une liste anglophone. Je ne sais pas si tu as posé ta question sur la liste française users@fr.openoffice.org Hi, This is an English speaking mail discussion list. If you haven't done so already, you may want to try posting your question on the users@fr.openoffice.org list. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Oracle ODBC not working in RC 2 - ping dbaneedsconfirm
Le mercredi 19 octobre 2005 à 08:51 -0400, Chuck a écrit : > Just thought I post a message here to see if anyone on the > dbaneedsconfirm list is reading. I opened issue 52451 several months ago > and it's still in unconfirmed state. I am wondering if anyone is even > looking at OOo 2.0 database issues. IMO the issue is too visible to be > ignoring at the RC level and possibly going to final release without > addressing. You still cannot use the Database tool with an Oracle > database connected by ODBC. Oracle is one of the most popular databases > in the world and ODBC is the primary method people use to connect a > non-Oracle client. > > This is the URL to the issue. > > http://www.openoffice.org/issues/show_bug.cgi?id=52451 > As a member of OOoQA I have trawled through some of the issues in dba, but there are many db engines to which I simply do not have access. Oracle is but one of them. I guess this is pretty much the case for many volunteers in the QA project who are interested in using dbs with OOo. The same goes for platform specific issues - how many home users have access to a Solaris machine, for example ? I currently work uniquely on the Linux/x86 and Mac/PPC architectures, and even PPC comes second to x86. It all comes down to numbers of volunteers having the requisite hardware/software setup to confirm the issue. Obviously, at least, no QA volunteers interested in solving QA bugs have the same setup as you do. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] reuse "AutoQuoting" from basic
Le jeudi 11 août 2005 à 20:33 +0200, Marc Santhoff a écrit : Hi Marc, > I made arbitrary combinations of columns one of which was named "D" and > had different types with different combinations of DB and driver. Any > time the name in question is involved, trouble is coming up. > > Using the table directly with mysql and ODBC or XMySQL works flawlessly. > Just on the off-chance here, because I don't know what is going on, but this wouldn't have anything to do with OOo getting the letter D confused as an instruction for date fields ? Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] report writer, crystal reports, etc
Le jeudi 04 août 2005 à 09:34 +1000, Daniel Kasak a écrit : Hi Daniel, > Another option would be to rewrite PDF::ReportWriter in ( God forbid ) > OOBasic or Java or something. Note that I'm not exactly offering to do > this port - I find detest OOBasic. But PDF::ReportWriter is weighing in > at only < 700 lines of code, and I use a lot of whitespace in my code, > so I'm sure people who have an affinity for OOBasic / Java / whatever > could port it relatively easily ... assuming OOo's PDF rendering support > is up to it. Does anyone here know would to script OOo's PDF output > thingy? Probably those who have an in depth knowledge of the framework API, since AFAIK the PDF rendering has to first go through the stage of constructing an OOo document. This means that if you were to use OOo Basic to port PDF::ReportWriter, you would have to translate the functions to their equivalents in a Writer / Calc / Impress document (probably I guess with Writer, since it has more advanced formatting options, although a Draw document might work). Then you could use the relevant API to convert to PDF, although I'm pretty certain at the moment that the attributes, properties and methods to do this are far less replete than with other PDF generation modules available in other scripting / programming languages (e.g. PHP, Perl, Python etc). Not that I know anything about it in detail mind you. > One of the invaluable features of PDF::API2 is the ability to > track *exactly* where you are on the page as well as the *exact* size of > text you are about to render, allowing you to do things like break to > the next page at the right time. Can you do this in OOo? This is > obviously required. > Yes, you can do this in OOo with OOo Basic, but it sometimes has unpleasant visual side effects, like making the cursor, and therefore the screen rendering, jump around the document. If you want an example of a PDF renderer written in OOoBasic that integrated more features than is currently available in the 1.1.x branch (the 2.0 branch does improve things), then you could look at the ExtendedPDF at http://www.jdisoftware.co.uk/pages/epdf-home.php > Who knows how to script OOo's PDF abilities? > Unfortunately, not I :-( Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] report writer, crystal reports, etc
Le mardi 02 août 2005 à 13:46 +0200, Frank Schönheit - Sun Microsystems Germany a écrit : Hi Frank, > Interesting. Do you know how they work? Do they create/manipulate the > mere files, or do they really connect to OOo and manipulate the docs by > using OOo? AFAIK, they merely create/manipulate the files, there is no connection involved as such, but I'm not an expert on these things. More info here : http://search.cpan.org/~jmgdoc/OpenOffice-OODoc/OODoc/Intro.pod Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] report writer, crystal reports, etc
Le mardi 02 août 2005 à 10:32 +0200, Frank Schönheit - Sun Microsystems Germany a écrit : Hi Frank, > How would a collaboration look like? OOo currently does not ship with > perl, nor does it have a UNO binding for perl [1], so how would OOo feed > your application with data? Are you interested in working on this? > Just for info : Although OOo doesn't come with Perl or have a UNO binding for Perl, there are Perl modules for creating and manipulating OOo docs in CPAN. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Mailing without the wizard
Le mardi 12 avril 2005 à 10:11 +0100, Sophie GAUTIER a écrit : > Hi all, > > Some of our users have requested to not use the wizard to mail merged > datas in letters. I thought the icône in F4 toolbars was the right one, > but no, the wizard was still hide behind it ;) > So I've found this good old dialog window in the Document tool bar :) > Questions : > Is it really the only place where a previous OOo user will find it and > get rid of the wizard, or am I missing something ? > Would it be possible to get the new functionnality to have the mail > merged in only one file using this old dialog window ? > Thanks in advance for your answer. > As a follow on to Sophie's question, it appears from reports on the French list that you can now no longer select the printer, because the print dialog doesn't come up. In 1.1.x, the mailing or serial letter component let you choose the printer for output after you had selected the records that you wanted to be inserted. This no longer appears to be possible - by design or bug ? Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] write - blocking - oo1.9.83 - myodbc - mysql
Le mardi 05 avril 2005 à 16:28 +0200, Cyrille Moureaux a écrit : Hi, > Has anyone encountered a hangup when performing a result modification > (write) from either a query or the table itself, and been forced to kill > OOo, though the change is taken into account in mySQL on the next start? > > See sql.log pasted below(*), is there also an OOo log (and if so where?). > > The rest of OOo base is terrific and close to Access, except regarding > response times for large databases. > I'll probably respond to the question on the French list too when I get around to it, but insofar as I'm concerned, the answer is yes, yes and yes. I have reported a number of bugs that cause OOo to segfault when writing or modifying a mysql db, even with the latest MyODBC installed. This was with m87. Some of these bugs have been corrected in later CWS that haven't yet been integrated into the developer releases. At the present time, OOo pre 2.0 and Mysql don't seem to want to play with each other very nicely. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] [OT]OOo, ODBC and PostgreSQL database
Le dimanche 13 mars 2005 à 01:53 -0500, Lawrence Harriott a écrit : Hi Lawrence, > > > Additionally, I have used the MySQL downloaded from MySQL and the one > > > supplied with MDK10.1. Same results. I think at this point it is fair to > > > say that the problems are not user errors. The ODBC interface between > > > MySQL / Postgresql and OOo is defective. On my MDK 10.1 box, I can access my MySQL databases both locally and remote via MyODBC and OOo, and on the whole it is pretty good. There are some problems I'm currently exeriencing with beta 2 OOo that mean that OOo crashes a lot, making any serious use of OOo impossible, but with the 1.1.4 provided by MDK things work pretty much as expected. I only hope that the chronic instability of the current Base module wrt mysql is resolved before final release, otherwise I shall just wait to upgrade until things do get fixed. If they don't, then I will stay with 1.1.x. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Small query about RESOLVED/FIXED issues
Le lundi 14 février 2005 à 21:51 +1100, Justin Clift a écrit : > Hi all, > > If I've come across a bug in OOo2 Base 680m77, and find an existing bug > for it in IZ (#42033) marked as RESOLVED/FIXED (680m75), does that means > it should be fixed already for m77 and I need to report it's still > broken, or not? > Well, it should be fixed, but if you are still having the problem, it might be worth opening it up again to see if it can be confirmed. All I can say is that the report wizard in m77 behaves oddly to say the least. I had to push the Next button several times to actually get it to do anything once I'd selected my base and the fields to be included (tested with a mysql db, and text fields). Oh, and it crashes a lot too, lots of Java exceptions thrown that are caught by an exception handler (the crash recovery manager I presume). Alex > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: [Marketing] Number of Connections for OOo Base
Le jeudi 03 février 2005 à 08:22 +0100, Ocke Janssen a écrit : > I'm sorry. I haven't made a list of what Access can what hsqldb can't > and vice versa. > But if you want to make one, we would place them on our website :-) More > information about hsqldb can be found here www.hsqldb.org. > More limitations of HSQLDB vs. Access, tested in m74 : - can't delete and recreate indexes - can't modify existing indexes - can't access your data outside of OOo, either via ODBC or JDBC. If you install the JDBC driver that comes natively with HSQLDB instead of that provided with OOo, your ODB document stops working - can't rename your database document without losing access to the data and tables - can't modify fields in a table once they've been created, you have to create a new field and then delete the old one If we find anymore, we'll let you know ;-) Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: [Marketing] Number of Connections for OOo Base
Le jeudi 03 février 2005 à 08:22 +0100, Ocke Janssen a écrit : > I'm sorry. I haven't made a list of what Access can what hsqldb can't > and vice versa. > But if you want to make one, we would place them on our website :-) More > information about hsqldb can be found here www.hsqldb.org. > Well here's one that users on the French dev n-l list have griped about as a major hindrance compared to MS-Access : no sharing. Apparently, you can not currently share a HSQLDB database file with concurrent multiple user access. This is very easy to do by all accounts using Access, but not so with HSQLDB. Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Add new datasource to Database - how?
Le lundi 31 janvier 2005 à 17:38 -0800, Ed Mansky a écrit : Ed, Exemplary /etc/odbc.ini, odbcinst.ini and user .odbc.ini files inline : /etc/odbc.ini (system wide DSN declarations) : [mrtip] Description = MySQL Driver = MySQL Server = localhost Database= mrtip Port= Socket = Option = Stmt= [Cabinet] Description = MySQL Driver = MySQL Server = 212.134.43.1 Database= ipdatabase Port= Socket = Option = Stmt= [ipdatabase] Description = MySQL Driver = MySQL Server = localhost Database= ipdatabase Port= Socket = Option = Stmt= /etc/odbcinst.ini : [MySQL] Description = MySQL Driver Driver = /usr/lib/libmyodbc3-3.51.09.so Setup = /usr/lib/libodbcmyS.so.1.0.0 FileUsage = 1 User .odbc.ini : [ipdatabase] Description = MySQL Driver Driver = MySQL Driver Server = 192.232.34.1 Database= ipdatabase Port= Socket = Option = Stmt= [CrashTest] Description = MySQL Driver Driver = MySQL Driver Server = localhost Database= crashtest Port= Socket = /var/lib/mysql/mysql.sock Option = Stmt= [FACTURIER] Description = MySQL Driver Driver = MySQL Driver Server = Database= FACTURIER Port= Socket = /var/lib/mysql/mysql.sock Option = Stmt= [CPA] Description = MySQL Driver Driver = MySQL Driver Server = localhost Database= CPA Port= Socket = /var/lib/mysql/mysql.sock Option = Stmt= HTH, Alex - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]