My append Query does not work

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

I do not understand my append qury does not work with message " Key
violation, I do not now what is wrong with this:

INSERT INTO bukuangkby ( NO_URTANGT, STAT_CODE, Addrs_ID, JnsAngt, NOIN,
TrnID, Dear, FNAME, MNAME, LNAME, NICKNAME, JenisKel, EmailAddress,
MobilPhone, MobilPhone2, [Language], Role, UrtRole, Hobbies, NotediRT,
TEMPTLAHIR, Imagepath, HLMNKEP_M, BAPTSOLH_M, TGLBPTIS_M, ATASSURT_M, ASAL1,
TGL_pen, ATSPERCA_M, ASAL2, HLMNKEP_K, PINDHKE_K, ATSSUR1_K, ATSSUR2_K,
KMATIAN_K, KELMURT_K, KETMURT_K, KELHILA_K, Note1, StatusN, Tgl_Nikah,
IDGereja, DateUpdated )
SELECT a.NO_URTANGT, a.STAT_CODE, a.Addrs_ID, a.JnsAngt, a.NOIN, a.TrnID,
a.Dear, a.FNAME, a.MNAME, a.LNAME, a.NICKNAME, a.JenisKel, a.EmailAddress,
a.MobilPhone, a.MobilPhone2, a.Language, a.Role, a.UrtRole, a.Hobbies,
a.NotediRT, a.TEMPTLAHIR, a.Imagepath, a.HLMNKEP_M, a.BAPTSOLH_M,
a.TGLBPTIS_M, a.ATASSURT_M, a.ASAL1, a.TGL_pen, a.ATSPERCA_M, a.ASAL2,
a.HLMNKEP_K, a.PINDHKE_K, a.ATSSUR1_K, a.ATSSUR2_K, a.KMATIAN_K, a.KELMURT_K,
a.KETMURT_K, a.KELHILA_K, a.Note1, a.StatusN, a.Tgl_Nikah, a.IDGereja,
a.DateUpdated
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].bukuangkby AS a
WHERE (((Exists (SELECT *
FROM bukuangkby
WHERE bukuangkby.NO_URTANGT = a.NO_URTANGT))=False));

I apprecieate your help.

Frank
 
You are attempting to append records that are duplicate of primary key or
other unique index.
Run a 'match' query to find the dupes.
 
Hello,

I do not understand my append qury does not work with message " Key
violation, I do not now what is wrong with this:

INSERT INTO bukuangkby ( NO_URTANGT, STAT_CODE, Addrs_ID, JnsAngt, NOIN,
TrnID, Dear, FNAME, MNAME, LNAME, NICKNAME, JenisKel, EmailAddress,
MobilPhone, MobilPhone2, [Language], Role, UrtRole, Hobbies, NotediRT,
TEMPTLAHIR, Imagepath, HLMNKEP_M, BAPTSOLH_M, TGLBPTIS_M, ATASSURT_M, ASAL1,
TGL_pen, ATSPERCA_M, ASAL2, HLMNKEP_K, PINDHKE_K, ATSSUR1_K, ATSSUR2_K,
KMATIAN_K, KELMURT_K, KETMURT_K, KELHILA_K, Note1, StatusN, Tgl_Nikah,
IDGereja, DateUpdated )
SELECT a.NO_URTANGT, a.STAT_CODE, a.Addrs_ID, a.JnsAngt, a.NOIN, a.TrnID,
a.Dear, a.FNAME, a.MNAME, a.LNAME, a.NICKNAME, a.JenisKel, a.EmailAddress,
a.MobilPhone, a.MobilPhone2, a.Language, a.Role, a.UrtRole, a.Hobbies,
a.NotediRT, a.TEMPTLAHIR, a.Imagepath, a.HLMNKEP_M, a.BAPTSOLH_M,
a.TGLBPTIS_M, a.ATASSURT_M, a.ASAL1, a.TGL_pen, a.ATSPERCA_M, a.ASAL2,
a.HLMNKEP_K, a.PINDHKE_K, a.ATSSUR1_K, a.ATSSUR2_K, a.KMATIAN_K, a.KELMURT_K,
a.KETMURT_K, a.KELHILA_K, a.Note1, a.StatusN, a.Tgl_Nikah, a.IDGereja,
a.DateUpdated
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].bukuangkby AS a
WHERE (((Exists (SELECT *
FROM bukuangkby
WHERE bukuangkby.NO_URTANGT = a.NO_URTANGT))=False));

I apprecieate your help.

Frank
Click to expand...

"Key Violation" means that you're violating referential integrity or a primary
key constraint. For instance if NO_URTANGT is the Primary Key of the table
bukuangkby, you may be inserting a record which would cause a duplicate in
that field; or if there is a relationship between this table and some other
table, you may be inserting a record which would cause an "orphan" record, a
nonexistant foreign key for example.
 
Back
Top