View Full Version : Engine error

14-06-2004, 06:55 PM
Does anyone know what this error message means ?;

DBISAM engine error #9729 duplicate key foundin the index " of the table
`Visual Zone`

Visual Zone is an addy to Zone Alarm.
Is there a fix or something I can do about this error, or is it something that I can ignore.It's the first time I have had this message.
I could do with some help in understanding what this is all about.
Running fully patched , up to date, XPhome.

14-06-2004, 07:05 PM

Duplicate key found in index <IndexName> of table <TableName>

This is a non-fatal error that occurs when an attempt is made to add a record to a table and the record would cause a duplicate key to be added for the primary index or for a secondary index that it is defined as being unique.

Primary indexes implicitly enforce uniqueness and therefore cannot permit duplicates to be added, while secondary indexes must be explicitly defined as unique.

... its a database problem.

14-06-2004, 07:23 PM
Thanks for that GF,
I can rest easier now.