Hello Robert, > Also the primary key is used on tables in all sorts of > databases. It is not only valid for Embedded databases. This line means that primary key is not only used in embedded database but also in external Database. You cannot add records to a table using base without a primary key, in any database engine, be it external or embedded. Pulkit Krishna
On Sat, Apr 18, 2020 at 6:24 PM Robert Großkopf <[email protected]> wrote: > Hi Rob, > > > > For example at the top on page 14 of "Introduction to Base (6.2)" > > chapter it says "The field names forename (first name), surname (last > > name), and birthday are likely to be clear. In addition, a field called > > ID was added. This field will later take a value which is unique for > > each record. A unique key field is necessary for the embedded database. > > Otherwise, no records can be entered in the table. This key field is > > called the /primary key/ in databases." > > > > The sentence "A unique key field is necessary for the embedded database" > > is imho not correct. a table has an unique key (primary key), not > > databases. > > The database HSQLDB requires this primary key for every tabe - if you > will work with the table in GUI. > > > Also the primary key is used on tables in all sorts of > > databases. It is not only valid for Embedded databases. > > This is wrong. Have a look at DBase, MySQL or, very simple, have a look > at HSQLDB without using the GUI. You could create tables in this > database without using a primary key and you could also add values to > this tables. The wizard works with this feature. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
