|
|
Error inserting the new record
From NeoWiki
(Difference between revisions)
( | 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.
