SQL Server 6.5 bug:
http://support.microsoft.com/support/kb/articles/Q198/5/72.ASP?LN=EN-US&SD=g
n&FR=0
-----Original Message-----
From: Ric Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 12:27 PM
To: CF-Talk
Subject: OT: SQL Server error.
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/[email protected]/
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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
