Topic: Unable to delete survey in R6 - error in SQL code
We recently tried to delete a survey that had become obsolete as we moved the records in a different one.
However, when we tried to remove the survey we got the error message "There is an error in the SQL code. The error message is!The DELETE statement conflicted with the REFERENCE constraint"FK_TAXON_PRIVATE_DATA_OCCURRENCE". The conflict occured in database"NBNDATA", table "dbo.Taxon_Private_Data", column'Taxon_Occurrence_Key"
This happened on both a workstation machine with R6 and the main server with R6.
Not sure where to go from here?
All the best,