Error inserting the new record

From NeoWiki

Revision as of 17:37, 12 January 2009 (edit) ( | contribs) (New page: ==Description== This error occurs in NeoBase. The message will read something like: '''Violation of unique index "index1"; duplicate value(s) for column(s) BBookType in statement [I...) ← Previous diff		Current revision (17:45, 12 January 2009) (edit) (undo) ( | contribs) (data entry error when using unique index)
(One intermediate revision not shown.)
Line 5:		Line 5:
	The message will read something like:		The message will read something like:
-	'''Violation of unique index "index1"; duplicate value(s) for column(s) BBookType in statement [INSER INTO "BBookType" ("BBookType") VALUES (?)]'''	+	'''Violation of unique index "index1"; duplicate value(s) for column(s) BBookType in statement [INSERT INTO "BBookType" ("BBookType") VALUES (?)]'''
	==Cause==		==Cause==
-	The error is caused when entering data into a table. At some point you have created an index for the field (column) in which you are entering data. (In this example "BBookType".) You also decided to make it a unique index. This means that whenever anyone saves a new record, the column is searched to check if the new entry already exists. If it does, this error message is generated.	+	The error is caused when entering data into an indexed table. At some point you have created an index for the field (column) in which you are entering data. (In this example the index is '''"index1"''' and the column,''' "BBookType"'''.) You also decided to make it a unique index. This means that whenever anyone saves a new record, the column is searched to check if the new entry already exists. If it does, this error message is generated.
		+
		+	The information between the '''[ ]''' at the end just details the name of the column(s) and the name of the table(s) that are being checked.
		+
		+	==Solution==
		+
		+	In this case, the error message doesn't really indicate a problem. It lets the user know that the data has already been entered at some other point.

---

Current revision

Description

This error occurs in NeoBase.

The message will read something like:

Violation of unique index "index1"; duplicate value(s) for column(s) BBookType in statement [INSERT INTO "BBookType" ("BBookType") VALUES (?)]

Cause

The error is caused when entering data into an indexed table. At some point you have created an index for the field (column) in which you are entering data. (In this example the index is "index1" and the column, "BBookType".) You also decided to make it a unique index. This means that whenever anyone saves a new record, the column is searched to check if the new entry already exists. If it does, this error message is generated.

The information between the [ ] at the end just details the name of the column(s) and the name of the table(s) that are being checked.

Solution

In this case, the error message doesn't really indicate a problem. It lets the user know that the data has already been entered at some other point.