Error inserting the new record

From NeoWiki

Revision as of 17:37, 12 January 2009 by ( | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

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 [INSER INTO "BBookType" ("BBookType") VALUES (?)]

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.

Personal tools