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

2012-04-21 Thread Mark Stanton
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... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

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

2012-04-20 Thread Mark Stanton
Hi Perrti, 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 not for the whole LibO suite. I think you

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

2012-04-20 Thread Mark Stanton
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. 4) Drag any other objects from the old

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

2012-04-20 Thread Dan Lewis
On Fri, 2012-04-20 at 13:08 +0100, 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

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

2012-04-18 Thread Mark Stanton
I think Andreas' approach for end users is a very good idea. I think, furthermore, that it starts to redefine how databases can be used. that's a good thing and going dowm that track will, I'm sure, lead to further developments. As such, yes, I think it would be a great idea to push that

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

2012-04-18 Thread Mark Stanton
I'm almost thinking of installing something like MySQL and writing my own front-end in Java. I'm sorry if I'm being slow, or not following the conversation properly (lots going on here at the moment), but, if you're thinking like that, what's wrong with Base? The things you'd need to do,

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

2012-04-16 Thread Mark Stanton
What was it you liked about Approach (I used that too)? I'm asking for feature ideas. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

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

2012-04-16 Thread Mark Stanton
- 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 limitation, isn't it? Mark Stanton One small step for mankind...

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

2012-04-16 Thread Mark Stanton
Sorry, I should have been more precise : Lotus Approach allowed a user to create a form based on a query of a collection of DBF tables and then be able to update them via the form Yes, because Approach had a database engine. Base doesn't. If you try to do this through Base with

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

2012-04-06 Thread Tom Davies
Hi :) It looks like the relationship between some of the tables has gone wonky.  Can you look at the relationships in the OOo and LO versions to see what is different?  The Base Guide hasn't really got into it yet but there is some stuff in Chapter 2 that you might find useful as it explains

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

2012-04-06 Thread drew jensen
On Fri, 2012-04-06 at 14:43 -0400, Dan Lewis wrote: On Fri, 2012-04-06 at 09:54 -0700, ptoye wrote: I have an OO database, and am trying out LO, and am having at least one problem. There is a form which is based on a query whose results are displayed in a grid, and various fields are copied