06. november 2003 - 13:23Der er
12 kommentarer og 1 løsning
MS SQL problemer med DELETE sætning
Hvad betyder denne fætter, får den når jeg prøver at slette en post.
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_staevne_spillested'. The conflict occurred in database 'test', table 'staevne', column 'spillested_ID'.
I Access slettede den posten fx. WHERE ID=1 i hovedtabellen og alle de poster i de andre tabeller der havde en relation til ID=1, jeg har lavet relationerne på samme måde i MS SQL basen.
Denne side indeholder artikler med forskellige perspektiver på Identity & Access Management i private og offentlige organisationer. Artiklerne behandler aktuelle IAM-emner og leveres af producenter, rådgivere og implementeringspartnere.
Tror det er fordi du selv skal fortælle at den skal bruge cascade update/delete, det er lige under relationship i design af tabellen (Enterprisemanager).
In table design right click in the area where the fields are and choose Relationships from the menu. Then you need to choose "Cascade Delete Related Records" and thats it!
Try making a database diagram and add the two tables. If they are related then there will be a relationship line between the primary and foreign keys. If they are not related then drag the primary key over to the foreign key to make the realtionship
terry -> I got it worked out, finally. My office version (2000) didn't provide me with "Cascade Delete Related Records" and one more, but XP and 2003 does - damn. Your right, after clicking "Cascade Delete Related Records" everything worked perfect
Strange that you say your Office version doesnt provide you with Cascade Delete... Its SQL Server that decides this not office! But as long as its working now thats what is important :o)
Yes, it's working great now - but it's true, I couldn't see "Cascade Delete Related Records" in Access 2000 (home and in school), but my body could see the 2 extra features in Office 2003???
alpapa
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
Ny bruger
Nybegynder
Opret
Preview
