Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


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 <robert@familiegrosskopf.de>
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: documentation+unsubscribe@global.libreoffice.org
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: documentation+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.