Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Girvin R. Herr
Dan, Chapter 2?? All I have is Chapter 1 - "Introducing Base" and Chapter 8 - "Getting Started with Base". I see there is a draft copy of Chapter 2 and 3 now. I will read them. Thanks. Girvin Herr Dan Lewis wrote: Have you read Chapter 2 of the Base Guide? (Planning/Designing your databas

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Dan Lewis
Have you read Chapter 2 of the Base Guide? (Planning/Designing your database) There are 56 pages in which I used this approach for all the parts of a database. There are many questions in it designed to help a person. --Dan https://wiki.documentfoundation.org/Documentation/Publications On 02

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-14 Thread Girvin R. Herr
Dan, This is good! It is a good start on an introduction to databases for newbies. It should be put in the Base manual? Girvin Herr Dan Lewis wrote: Some basics about creating a database: 1) You begin with data that you want to use for some purpose or purposes. 2) Then you design the d

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-13 Thread Dan Lewis
On 02/11/2013 05:31 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > ` > On 02/11/2013 09:18 AM, Uwe Brauer wrote: >> >> Uwe Brauer > How do you define an "intrinsic database"? I do not understand > the term. Well in my understanding there are two possibilit

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Dan Lewis
On 02/12/2013 12:03 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > Perhaps you need to learn more about primary keys, foreign keys, > and the relationship that must exist between them. Another topic that > would help is normalizing tables. Still another topic is constraint

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Tom Davies
ice.org >Sent: Tuesday, 12 February 2013, 17:03 >Subject: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only >between primaries keys? > >>> "Dan" == Dan Lewis writes: > > >  >      Perhaps you need to learn more about primary keys, foreign

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Alex Thurgood
On 02/12/2013 06:03 PM, Uwe Brauer wrote: Hi Uwe, Robert Grosskopf wrote a handbook in German that should be available on the German LO wiki somewhere. >> As far as MySQL problems, I think I tried to modify fields in a >> table while using MySQL. They were not saved either. You mi

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Alex Thurgood
On 02/12/2013 05:59 PM, Uwe Brauer wrote: Hi Uwe, > Well show engines; > showed > > InnoDB | YES | Supports transactions | YES | YES | YES > > So I presume the answer is yes. > In theory, yes, but you might want to check each table to see whether it does actually use

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Uwe Brauer
>> "Dan" == Dan Lewis writes: > Perhaps you need to learn more about primary keys, foreign keys, > and the relationship that must exist between them. Another topic that > would help is normalizing tables. Still another topic is constraints > that must be applied to either type o

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-12 Thread Uwe Brauer
>> "Alex" == Alex Thurgood writes: > On 02/11/2013 11:31 PM, Uwe Brauer wrote: > Hi Uwe, >> As I said, in another mail, when I connect the data base to mysql via >> ODBC then I can set more relations, but they are not saved.. >> > I take it that you are using InnoDB engine i

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Alex Thurgood
On 02/11/2013 11:31 PM, Uwe Brauer wrote: Hi Uwe, > As I said, in another mail, when I connect the data base to mysql via > ODBC then I can set more relations, but they are not saved.. > I take it that you are using InnoDB engine in your mysql db ? Otherwise, e.g. if you are using myisam or h

Re: [libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Dan Lewis
On 02/11/2013 05:31 PM, Uwe Brauer wrote: "Dan" == Dan Lewis writes: > ` > On 02/11/2013 09:18 AM, Uwe Brauer wrote: >> >> Uwe Brauer > How do you define an "intrinsic database"? I do not understand > the term. Well in my understanding there are two possibilit

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Uwe Brauer
>> "Alexander" == Alexander Thurgood writes: > Le 11/02/13 15:18, Uwe Brauer a écrit : > Hi Uwe, >> Now I want to edit the relation and I am offered the possibility to add >> more fields. So I select the notes file in either table but I receive >> the following error. >> >

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Uwe Brauer
>> "Dan" == Dan Lewis writes: > ` > On 02/11/2013 09:18 AM, Uwe Brauer wrote: >> >> Uwe Brauer > How do you define an "intrinsic database"? I do not understand > the term. Well in my understanding there are two possibilities, - either Base can connect to an e

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

2013-02-11 Thread Alexander Thurgood
Le 11/02/13 15:18, Uwe Brauer a écrit : Hi Uwe, > Now I want to edit the relation and I am offered the possibility to add > more fields. So I select the notes file in either table but I receive > the following error. > > Primary or unique constraint required on main table. > "Accounts" in stat