|
|
Error inserting the new record
From NeoWiki
Revision as of 17:37, 12 January 2009 by ( | contribs)
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.
