Occasionally I'm getting the following error. There is no contraint or primary key on this table, what is causing this and how can I avoid this problem.
thanks
randy


ElevateDB Error #1004 The primary key constraint __PrimaryKey has been violated (Duplicate key 6317 found)

Randy,

<< Occasionally I'm getting the following error. There is no contraint or
primary key on this table, what is causing this and how can I avoid this
problem. >>

Repair the table - most likely it is corrupted.  There is an internal
primary key on the RowID when you don't explicitly define one, and you
should never run into duplicate RowID values unless the table/indexes have
been corrupted.

--
Tim Young
Elevate Software
www.elevatesoft.com