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

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

2012-04-21 Thread Alexander Thurgood
Le 21/04/12 10:28, Ian Whitfield a écrit : Hi Ian, 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. You only needed to

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

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

2012-04-21 Thread Andreas Säger
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 8b7668689cd208867c77f2f4d77922de

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

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

2012-04-21 Thread Andreas Säger
Am 21.04.2012 18:58, Mark Stanton wrote: Copying the structure and data in one go, as offered by the import wizard, never creates any auto-ID fields. Would this be a sensible improvement to make? Mark Stanton One small step for mankind... Hello Mark, Yes, it would be useful to have more

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

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

2012-04-20 Thread Andreas Säger
Am 20.04.2012 10:48, Ian Whitfield wrote: 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

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

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

2012-04-20 Thread Alexander Thurgood
Le 20/04/12 16:48, Ian Whitfield a écrit : Hi Ian, OK Step 1. Done (I downloaded and extracted hsqldb 2.2.8 to my 'software' folder) Step 2. The lib folder is under root and all files are grey-ed out in Class Path?? Why are you trying to put the jar in your root's lib folder, or are you

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

2012-04-20 Thread Andreas Säger
Am 20.04.2012 14:08, Mark Stanton wrote: Hi Ian, The easy version is :- 1) Open your database with the HSQLDB embedded data. 2) In a separate window, create a new database with any other kind of data engine. 3) Drag the tables from the embedded database to the new database, one by one.

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

2012-04-20 Thread Andreas Säger
Am 20.04.2012 16:48, Ian Whitfield wrote: /home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar menu:ToolsOptionsJava Button Class Path Button Add Archive and point to the above one. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

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,

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

2012-04-19 Thread Andreas Säger
Am 19.04.2012 13:00, ptoye wrote: Mark Stanton wrote I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. You do it all the time. All of your input forms are attached to Writer documents. All I originally asked

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

2012-04-19 Thread ptoye
Andreas Säger wrote Am 19.04.2012 13:00, ptoye wrote: I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. You do it all the time. All of your input forms are attached to Writer documents. All I originally

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

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

2012-04-19 Thread Andreas Säger
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 real future forLibO's Base module, perhaps

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

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 18:14, Andreas Säger a écrit : Hi all, The easiest improvements in my honest opinion: - Wipe out the .odb container all together and get back to the configuration of database access in OOo 1. Back to external databases with configuration data in configuration files, forms and

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

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 20:13, ptoye a écrit : Is there any point in suggesting that LibO and OO should continue to diverge? I'd have thought convergence would be more productive, both in terms of the development which seems too thinly spread, and for users who might even see a serious contender

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

2012-04-18 Thread Alexander Thurgood
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 rather well on the whole, albeit with tweaking, and

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

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

2012-04-17 Thread ptoye
NoOp wrote On 04/15/2012 08:58 AM, David wrote: ... What database doe you think works better than OpenOffice or LibreOffice? Pick. I don't have any views on this matter. I vaguely remember that Lotus Approach allowed far more flexibility in allowing updates to multiple tables,

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

2012-04-17 Thread Andreas Säger
Am 17.04.2012 10:52, ptoye wrote: Access allows update queries, which are sadly missing from LO/OO. 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

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

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

2012-04-17 Thread ptoye
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 somewhere in the .odb

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

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

2012-04-17 Thread Andreas Säger
Am 17.04.2012 11: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

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

2012-04-17 Thread Andreas Säger
Am 17.04.2012 11:28, Ian Whitfield wrote: 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

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

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

2012-04-17 Thread Andreas Säger
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 to complete it and repair all discrepancies in the program and between the program and it’s documentation! There is so much good done

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

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

2012-04-17 Thread Andreas Säger
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 honest opinion: - Wipe out the .odb container all

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

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

2012-04-17 Thread ptoye
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. I'm almost thinking of

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.

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

2012-04-17 Thread Andreas Säger
Am 17.04.2012 19:23, Tom Davies wrote: Hi :) It looks like most of this can be done without touching Base itself? Is LO able to use databases in this way already? Is it something that could be passed to the devs list an/or the BoD discussion list? Something like this could be phrased to

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

2012-04-16 Thread Alexander Thurgood
Le 16/04/12 10:09, Mark Stanton a écrit : Hi Mark, What was it you liked about Approach (I used that too)? I'm asking for feature ideas. As a former Lotus Approach user, off the cuff : - multiple table query/update support - add/delete/modify/clone data button objects that worked

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

2012-04-16 Thread Andreas Säger
Am 16.04.2012 14:49, Mark Stanton wrote: - multiple table query/update support Multi-table update support is an SQL limitation, isn't it? At least it requires that a foreign key is linked to another table's unique (primary) key, otherwise it is uncertain which one of the related rows you

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

2012-04-16 Thread Alexander Thurgood
Le 16/04/12 14:49, Mark Stanton a écrit : Hi Mark, - multiple table query/update support Multi-tabe query is available, surely? Where it's not available is in file mode when there's no backing database engine. Or having I missed somthing? Multi-table update support is an SQL

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

2012-04-16 Thread Andreas Säger
Am 15.04.2012 17:48, 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.

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

2012-04-16 Thread NoOp
On 04/15/2012 08:58 AM, David wrote: ... What database doe you think works better than OpenOffice or LibreOffice? Pick. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

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

2012-04-15 Thread Tom
Hi :) 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. MS Office tries to be relevant to all markets by being heavily bloated and able to do everything so it's far heavier, more bloated and slower than anyone would

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

2012-04-15 Thread ptoye
So how does development happen? There seem to be two bug lists, and as I've demonstrated, they give different results on the same data (yuk). MS win by persuading industry (who are by far the dominant buyers - we single users are very much a minority and ignored by MS) that intercommunicability

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

2012-04-15 Thread Tom
Hi :) We are not all single users here! Far from it! There are a lot of companies invested in LibreOffice/OpenOffice and even more if you include other products that use the OpenDocument Format. Mostly they are not names well recognised by Windows desktop users but some may ring a bell; Google,

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

2012-04-15 Thread ptoye
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 keen to automate any process, but the OO Basic learning curve turns many people off (as far as I can see from bulletin

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

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

2012-04-15 Thread Andreas Säger
ptoye wrote 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 keen to automate any process, but the OO Basic learning curve turns many people off (as far as I

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

2012-04-15 Thread ptoye
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. But I'm not trying to use a database

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.

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

2012-04-15 Thread ptoye
David-4 wrote What database doe you think works better than OpenOffice or LibreOffice? I don't. I found MS Access as easy to use and with a better-developed macro language. But I was not doing anything too complicated with it. The over-complex API (or is it just the way the documentation

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

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

2012-04-15 Thread ptoye
Tom wrote Hi :) From what Andreas and others say i think that is most of the problem with Base.  Too many great ideas that only got half done.  I guess it might be the same with macros.  Apparently Andrew Pitonyak's guide is one of the best ways to get into macro programming

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

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

2012-04-14 Thread ptoye
I've not been keeping up with the OO/LO saga. It strikes me as a bit mad to have two different products, each being developed with minimal resources, trying to compete with the MS juggernaut. United we stand, divided we fall. But that's a bit off-topic. Anyway, I've reported this as a bug to

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

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

2012-04-12 Thread ptoye
Not heard anything recently about my main problem (the fonts issue is a sideline). Anyone got any ideas? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3905090.html Sent from the Users mailing list archive at

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

2012-04-12 Thread Andreas Säger
Try if a manual refresh helps. Use the button in the middle of the navigation toolbar. Work-around: Use the ID numbers together with a list box. So the actual field value is the ID masked by the list box text. In addition you can have an editable record set. -- View this message in context:

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

2012-04-09 Thread ptoye
More developments - I copied the database to a Linux system and it opens correctly. So it seems to be a Windows-only issue. But the formatting on the Linux system was terrible! - Peter -- View this message in context:

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

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

2012-04-09 Thread ptoye
Ubuntu. I think it's a fonts issue. But the formatting isn't exactly the problem. I'm far more worried about the problems in Windows, which is my normal desktop environment. - Peter -- View this message in context:

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

2012-04-07 Thread ptoye
Good idea, but the relationships haven't changed from OO. The fields in the grid which have relationships are supplier and Region (both links into other tables by an identifier field). The former is displayed incorrectly in the grid, the latter correctly. Name and comments are both displayed

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

2012-04-07 Thread ptoye
Thanks for the interest, Dan. The answers are: LO: LibreOffice 3.5.2.2 Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f OO: 3.3.0 build 9567 OS: Windows 7 64-bit Home Premium Table contents: They look the same. At least, there aren't any obvious oddities. (I've not exported them and done a