Re: [libreoffice-users] definition of flat/relational database

2013-03-08 Thread Wolfgang Keller
> May I suggest you to contact Kexi main developer, Jarosław Staniek, > with this proposal? You will find his e-mail address here: I'm subscribed to the Kexi mailinglist, and the subject has been regularly invoked by various users there. Without composite keys you can't even implement M:N relati

Re: [libreoffice-users] definition of flat/relational database

2013-03-08 Thread Wolfgang Keller
> > If LO Base is not enough for you because you need more application > > logic, then there are two VFP developers who have implemented their > > own successor to VFP. Cross-platform, open-source, free. It's > > called Dabo (www.dabodev.com) and it uses Python as the programming > > language. If y

Re: [libreoffice-users] definition of flat/relational database

2013-03-06 Thread Mark Stanton
Dan, As I said in my response above, the distinction that LO is making is "database engine call or manipulate file directly". If it manipulates files directly it does it with simple, slightly extended, text manipulation. LO has no database functionality itself, for such functions it can only

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Girvin R. Herr
Dan Lewis wrote: I'm still don't understand what the structure of dBase2 is. How can you use two or more tables in a query for example using this database engine? Some light reading required? https://en.wikipedia.org/wiki/DBase File formats: dbase II: http://www.fileformat.in

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Mirosław Zalewski
On 05/03/2013 at 20:13, Wolfgang Keller wrote: > Kexi will become usable as soon as it supports composite (natural) keys. May I suggest you to contact Kexi main developer, Jarosław Staniek, with this proposal? You will find his e-mail address here: From

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Girvin R. Herr
Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as soon as it support

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Dan Lewis
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or mo

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Steve Edmonds
On 2013-03-06 08:13, Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as soon

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread J.A. de Vries
On 2013-03-05 20:12, Wolfgang Keller wrote:>> I am still waiting for a database program that will allow >> me to create applications (not pieces of applications, like queries >> and forms) without having to learn C (this old dog is not going to >> learn that new trick!). > > If LO Base is not enoug

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Wolfgang Keller
> I am still waiting for a database program that will allow > me to create applications (not pieces of applications, like queries > and forms) without having to learn C (this old dog is not going to > learn that new trick!). If LO Base is not enough for you because you need more application logic,

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Wolfgang Keller
> I don't know if it will be suitable, but you can try Kexi (part of > Calligra suite, I believe; but you can install it separately). I > heard it is much better than LO Base, but I don't know enough to > verify that statement. Kexi will become usable as soon as it supports composite (natural) key

Re: [libreoffice-users] definition of flat/relational database

2013-03-04 Thread Tom Davies
.libreoffice.org >Sent: Monday, 4 March 2013, 8:35 >Subject: Re: [libreoffice-users] definition of flat/relational database > >On 03/03/2013 at 19:47, "John R. Sowden" wrote: > >>    I am still waiting for a database program that will allow me to >> creat

Re: [libreoffice-users] definition of flat/relational database

2013-03-04 Thread Mark Stanton
> Thank God Linux came arround when it did... >I am still waiting for a database program that will allow me to > create applications I feel your pain. I was a professional VFP developer and have now moved to Linux and have the same problem. However, I am wondering if the "one solid lump" ap

Re: [libreoffice-users] definition of flat/relational database

2013-03-04 Thread Mirosław Zalewski
On 03/03/2013 at 19:47, "John R. Sowden" wrote: >I am still waiting for a database program that will allow me to > create applications (not pieces of applications, like queries and forms) > without having to learn C (this old dog is not going to learn that new > trick!). I don't know if i

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Mark LaPierre
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or mor

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 10:50 AM, Wolfgang Keller wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The main issue for me would be whether the database "management system" (some call it "engine" or whatever) actually enforces relational in

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 10:28 AM, Jay Lozier wrote: On 03/03/2013 12:39 PM, Mark Stanton wrote: I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visua

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 09:30 AM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have a di

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Wolfgang Keller
> Why do the Libreoffice powers that be define dbase/xbase as a flat > file database, not a relational database. The main issue for me would be whether the database "management system" (some call it "engine" or whatever) actually enforces relational integrity (foreign key constraints) between tab

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 09:39 AM, Mark Stanton wrote: I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP,

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Jay Lozier
On 03/03/2013 12:39 PM, Mark Stanton wrote: I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP,

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
On 03/03/2013 07:27 AM, Dan Lewis wrote: On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat data

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Mark Stanton
I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP, whyzatt then? ;) ), however it'll be a Wind

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Regina Henschel
Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have a direct link? *Flat databases* A flat database

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Dan Lewis
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or mo

[libreoffice-users] definition of flat/relational database

2013-03-03 Thread John R. Sowden
Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or more tables, each containing one or more fields