Error inserting the new record

From NeoWiki

(Difference between revisions)
Jump to: navigation, search

( | 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...)
Next diff →

Revision as of 17:37, 12 January 2009

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