Hi All I have an SQL update that is performing strangely.
Can anyone tell me what SQL OLEDB Error code 3621 refers to? I also get Error evaluating CHECK constraint in my Access 2000 test database. In a nutshell, I'm trying to copy a record within a database. In this case there are two tables, the primary keys are combined from the first three columns in each table (don't ask...) so I can't use an Insert Select because the PKs are part of the record. So I'm running a query on the record to be copied, then creating a new record by inserting form data to the primary key fields, and then performing an update on this new record by inserting the records returned from step one. All within one template. Funnily enough the Access 97 version works perfectly. So why the error codes? Any suggestions gratefully received Tris ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
