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: snip 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

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

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 database)

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 elderdanle...@gmail.com 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

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

2013-02-12 Thread Uwe Brauer
Alex == Alex Thurgood alex.thurg...@gmail.com 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

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

2013-02-12 Thread Uwe Brauer
Dan == Dan Lewis elderdanle...@gmail.com 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

[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 the

[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 might

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

2013-02-12 Thread Tom Davies
@global.libreoffice.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 elderdanle...@gmail.com writes:         Perhaps you need to learn more about primary keys, foreign keys,   and the relationship

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 elderdanle...@gmail.com 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

[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 statement

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

2013-02-11 Thread Uwe Brauer
Dan == Dan Lewis elderdanle...@gmail.com 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

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

2013-02-11 Thread Uwe Brauer
Alexander == Alexander Thurgood alex.thurg...@gmail.com 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.

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 elderdanle...@gmail.com 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

[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