Forum

Welcome Guest! To enable all features please try to register or login.
Napaka pri iskanju stanja
Options Go to last post Go to first unread
Previous Topic Next Topic
fibomed
#1 Posted : 10 January 2012 13:32:37(UTC)
fibomed

Rank: Member

Joined: 10/01/2012(UTC)
Posts: 2
Pozdravljeni,

ob iskanju stanja preko čarovnika mi javlja napako :" the statement has been terminated.The INSERT statement conflited with the FOREIGN KEY constraint "rtHE_MoveItem_tHE_SetCountry_6" The conflict occured in database "XY" table dbo.tHE_SerCountry column "acOrigin"

A ima morda kdo kakšno idejo kaj je narobe ??

JUREBOV
#2 Posted : 10 January 2012 14:45:57(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Gre za napako referenčne integritete na vaši bazi. Na poziciji računa (ident) je polje "Poreklo" (acorigin), ki je povezano z poljem "Šifrant držav in carinsko tarifo" v šifrantu (tabeli) držav. Ta dva podatka morata biti enaka, v vašem primeru pa imate verjetno na poziciji identa vnešeno neko poreklo oz. šifro države, ki pa ne obstaja v šifrantu držav(?)
Pregled napak RI si lahko pogledate v administratorski konzoli - podatkovna baza - kontrola referenčne integritete (tudi tu lahko popravljate podatke): https://usersite.datalab.eu/Wiki.../Default.aspx?tocid=2158
Lp, J.

Edited by user 10 January 2012 14:46:47(UTC)  | Reason: Not specified
fibomed
#3 Posted : 10 January 2012 15:29:14(UTC)
fibomed

Rank: Member

Joined: 10/01/2012(UTC)
Posts: 2
Kaj pa v primeru da v referenčni integriteti ne pusti spreminjati kode države ?? Obarvano rdeče ne moreš spreminjati, kljub pritiskom na omenjene gumbe.

LP
JUREBOV
#4 Posted : 10 January 2012 17:15:34(UTC)
JUREBOV

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 204

Was thanked: 2 time(s) in 2 post(s)
Preverite v š. držav obstoj le teh. V š. držav lahko na gumbu za "uvoz/izvoz podatkov" uporabite prenos držav v šifrant (najbolje dodajanje).
Lp, J.
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0,532 seconds.