|
|
Error inserting the new record
From NeoWiki
| Revision as of 17:42, 12 January 2009 (edit) ( | contribs) ← Previous diff |
Current revision (17:45, 12 January 2009) (edit) (undo) ( | contribs) (data entry error when using unique index) |
||
| Line 9: | Line 9: | ||
| ==Cause== | ==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 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 | + | 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== | ==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. | 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.
