Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-23 Thread Ian Whitfield
On 21/04/2012 16:58, Ian Whitfield wrote: So what can be causing the problem?? I'm a little despondent - over a week since I started this exercise and I'm still nowhere. Also 3 days since my last post and no suggestions. Can anyone help me out?? I stand at the point of having HSQLDB2.2.8

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-23 Thread Dan Lewis
On Mon, 2012-04-23 at 11:31 +0200, Ian Whitfield wrote: On 21/04/2012 16:58, Ian Whitfield wrote: So what can be causing the problem?? I'm a little despondent - over a week since I started this exercise and I'm still nowhere. Also 3 days since my last post and no suggestions. Can

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Ian Whitfield
On 20/04/2012 18:51, Alexander Thurgood wrote: Check the permissions on your /software folder and also the permissions on the hsqldb folder and any files in it. The jar file at least, needs to have the executable bit set. OK - one step at a time I guess I checked the permissions on the

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Ian Whitfield
On 21/04/2012 10:48, Alexander Thurgood wrote: 1) Remove the links that you added to the Classpath parameter to : /opt/libreoffice3.5/programs/classes/hsqldb.jar /opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar LO already knows where to find them. From what you describe as your actions, you

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Ian Whitfield
In addition to what I wrote a couple of hours back - I have just tried a couple of other things... I linked the class path to the two files mentioned in the Error Box. LO accepted both of them OK AND popped-up a box warning me to re-start LO and then worked fine. BUT both are linked to the

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Ian Whitfield
On 21/04/2012 16:08, Andreas Säger wrote: Am 21.04.2012 15:46, Ian Whitfield wrote: This leaves me wondering if the .jre file is at fault. It's new, (I downloaded it yesterday), and is 1.4Mb in size?? This is the md5sum of my working hsqldb-2.2.8.zip: $ md5sum ~/download/hsqldb-2.2.8.zip

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-21 Thread Tom Davies
:) --- On Sat, 21/4/12, Ian Whitfield whitfi...@telkomsa.net wrote: From: Ian Whitfield whitfi...@telkomsa.net Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Saturday, 21 April, 2012, 14:46 In addition to what I wrote a couple of hours

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread MiguelAngel
El 20/04/12 1:18, Andreas Säger escribió: Am 19.04.2012 20:45, Pertti Rönnberg wrote: LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Ian Whitfield
On 20/04/2012 01:18, Andreas Säger wrote: There are not many users who suffer from the limited capabilities of HSQL 1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. OK Andreas (or

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Pertti Rönnberg
On 20.4.2012 11:00, MiguelAngel wrote: One for you. Much users even don't read the program's help. A light read over all the help, shows very well what the program can do and how, many samples there, and also can solve the majority of the cuestions on daily use. To drive a car is needed a

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Ian Whitfield
On 20/04/2012 14:57, Andreas Säger wrote: 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the Class Path setting in the LibreOffice Java options to hsqldb.jar in your subdirectory lib. Thanks Andreas OK Step 1. Done (I downloaded and extracted

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Nino Novak
On Friday 20 April 2012, 16:54:54 Pertti Rönnberg wrote: On 20.4.2012 11:00, MiguelAngel wrote: One for you. Much users even don't read the program's help... May I correct you, you do not need a license for driving a car... Pertti, the problem is, that software usability today in most

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Jean-Francois Nifenecker
Le 20/04/2012 18:17, Nino Novak a écrit : Pertti, the problem is, that software usability today in most cases is still far from being intuitive. I fully share this. Though some (eyes looking to Redmond) claim computing is intuitive, I'm seeing everyday that it is *not* and that using a

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Tom Davies
/4/12, Nino Novak nn.l...@kflog.org wrote: From: Nino Novak nn.l...@kflog.org Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 20 April, 2012, 17:17 On Friday 20 April 2012, 16:54:54 Pertti Rönnberg wrote: On 20.4.2012

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Jean-Francois Nifenecker
Le 20/04/2012 16:48, Ian Whitfield a écrit : On 20/04/2012 14:57, Andreas Säger wrote: 1) Download and extract the latest HSQLDB to some place. No installation required. 2) Point the Class Path setting in the LibreOffice Java options to hsqldb.jar in your subdirectory lib. Thanks Andreas OK

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Jean-Francois Nifenecker
Le 20/04/2012 18:30, Tom Davies a écrit : Hi :) I think that's a tad unfair. People have grown-up learning MS's ways of doing things and so intuitive means doing things MS's way, ie the ways that encourages a proliferation of viruses and causes slowdowns and encourages bad-habits. Intuitive?

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Tom Davies
Hi :) +1 I can definitely agree with this!  Well said! :) Regards from Tom :) --- On Fri, 20/4/12, Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net wrote: From: Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net Subject: Re: [libreoffice-users] Re: Problems importing

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-20 Thread Jay Lozier
On 04/20/2012 12:27 PM, Jean-Francois Nifenecker wrote: Le 20/04/2012 18:17, Nino Novak a écrit : Pertti, the problem is, that software usability today in most cases is still far from being intuitive. I fully share this. Though some (eyes looking to Redmond) claim computing is intuitive,

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-19 Thread Pertti Rönnberg
, Alexander Thurgoodalex.thurg...@gmail.com wrote: From: Alexander Thurgoodalex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:05 Le 17/04/12 18:14, Andreas Säger a écrit : Hi all

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:17 Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-18 Thread Ian Whitfield
On 18/04/2012 11:17, Alexander Thurgood wrote: Le 17/04/12 11:28, Ian Whitfield a écrit : Hi Ian, While I might agree with your statements with regard to the integrated use of HSQLDB, I would differ with regard to hooking up Base to various server backends, which in my experience do work

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
are happier and growing faster.  Regards from Tom :) --- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
.  Regards from Tom :) --- On Wed, 18/4/12, Fernand Vanrie s...@pmgroup.be wrote: From: Fernand Vanrie s...@pmgroup.be Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:55 On 17/04/2012 23:58, Andreas

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Wednesday, 18 April, 2012, 10:05 Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, The easiest improvements in my

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Ian Whitfield
On 04/15/2012 08:58 AM, David wrote: ... What database doe you think works better than OpenOffice or LibreOffice? I don't have any views on this matter. After using OO/LO Base for over 5 years now I gave up last month after the latest crash. It has been an ongoing battle to keep my DB

off-list Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
...@telkomsa.net Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 10:28   On 04/15/2012 08:58 AM, David wrote: ...     What database doe you think works better than OpenOffice or LibreOffice?   I don't

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
Hi :) Dohhh, that last post was meant to be off-list!! Regards from Tom :) --- On Tue, 17/4/12, Ian Whitfield whitfi...@telkomsa.net wrote: From: Ian Whitfield whitfi...@telkomsa.net Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
appears to be better than it was.  Regards from Tom :) --- On Tue, 17/4/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 12

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Pertti Rönnberg
On 17.4.2012 12:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 15:03 On 17.4.2012 12:34, ptoye wrote: Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 16:28 Am 17.04.2012 16:03, Pertti Rönnberg wrote: To the LibO-folks and developers I repeat: Stop developing LibO-Base;go back to the latest stable version and start

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Tom Davies
the old way might put them off. Regards from Tom :) --- On Tue, 17/4/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Tuesday, 17 April, 2012, 17:14

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Fernand Vanrie
On 17/04/2012 18:14, Andreas Säger wrote: Am 17.04.2012 17:38, Tom Davies wrote: Hi :) Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks need to be applied? Are the tweaks vital or could they left out? Regards from Tom :) The easiest improvements in my

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Steve Edmonds
On 2012-04-18 06:13, ptoye wrote: Pertti Rönnberg wrote Well said Peter! I totally and completely agree with you and Ian Whitfield. Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier.

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Jay Lozier
On 04/17/2012 02:13 PM, ptoye wrote: Pertti Rönnberg wrote Well said Peter! I totally and completely agree with you and Ian Whitfield. Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier.

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Tom Davies
] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Sunday, 15 April, 2012, 14:34 Glad to hear it. But IMHO Base is just nowhere compared  to Access (which itself isn't much to shout about). And OO Basic compared to VBA similarly.  As an ex-programmer I'm always

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread David
On 4/15/2012 11:48 AM, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts.

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Tom Davies
://wiki.documentfoundation.org/Documentation/Publications#Programmers Regards from Tom :) --- On Sun, 15/4/12, David dgbo...@gmail.com wrote: From: David dgbo...@gmail.com Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Sunday, 15 April, 2012, 16:58

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Tom Davies
Hi :) True.  I was hoping it was 2 separate questions; 1 about Base and the other about macros.  Both together is likely to be tricky.  Regards from Tom :) --- On Sun, 15/4/12, ptoye l...@ptoye.com wrote: From: ptoye l...@ptoye.com Subject: [libreoffice-users] Re: Problems importing an OO

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Jay Lozier
On 04/15/2012 11:58 AM, David wrote: On 4/15/2012 11:48 AM, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Tom Davies
Hi :) Lol, i was expecting you to say Postgresql.  There are other much lighter-weight ones more suitable for small databases but we almost never hear about them.  Perhaps SqLite or something?  I guess this is a topic for a different thread.  Regards from Tom :) --- On Sun, 15/4/12, Jay

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Cor Nouws
Tom wrote (15-04-12 13:34) Well, in many ways it's really only 1 product but in other ways it allows each to focus on slightly different niches in the market. Well, LibreOffice came from the same code base. But seeing all that has been done for LibreOffice the last year, it's hard to say any

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-15 Thread Steve Edmonds
On 2012-04-16 03:58, David wrote: On 4/15/2012 11:48 AM, ptoye wrote: Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-13 Thread Tom Davies
-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Friday, 13 April, 2012, 15:30 Manual refresh doesn't help. I'm afraid. And the workaround is even simpler - keep using Open Office! - Peter -- View this message in context: http

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-09 Thread Tom Davies
those same fonts on Windows if you wanted to use the front-end on Windows again) Regards from Tom :) --- On Mon, 9/4/12, ptoye l...@ptoye.com wrote: From: ptoye l...@ptoye.com Subject: [libreoffice-users] Re: Problems importing an OO database into LO To: users@global.libreoffice.org Date: Monday