I just started getting this error in one of my SQLServer 6.5 db's.
I don't know what could be causing it. The primarykey/identity
column is named FolderID. Why would it be trying to insert a
duplicate if it's an autonumber?
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'PK__Folders__FolderI__198AD3B0': Attempt to insert duplicate key
in object 'Folders'.
SQL = "INSERT INTO Folders ( ParentID, Name, Description,
ateAdded )VALUES( 7, 'test', 'test', {ts '2000-10-04 12:27:18'} );"
Thanks.
Ric Smith
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
