OK Bos,
Ini meta data yg ada saya kopi ke sini,
Ini adalah untuk table gudang :
CREATE TABLE "GUDANG"
(
"KODEGDG" VARCHAR(15) NOT NULL,
"NAMAGDG" VARCHAR(30) NOT NULL,
"KET" VARCHAR(50),
"JMLSLOT" INTEGER,
"JMLZONE" INTEGER,
"JENISGDG" SMALLINT NOT NULL,
"LOKASI" VARCHAR(45),
"SIFAT" SMALLINT NOT NULL,
PRIMARY KEY ("KODEGDG")
);
ALTER TABLE "GUDANG" ADD CONSTRAINT "FK_GUDANG_JENISGDG" FOREIGN KEY
("JENISGDG") REFERENCES JENISGUDANG ("NOGDG") ON UPDATE CASCADE ON DELETE
CASCADE;
ALTER TABLE "GUDANG" ADD CONSTRAINT "FK_GUDANG_SIFATGUDANG" FOREIGN KEY
("SIFAT") REFERENCES SIFATGUDANG ("NOGDG") ON UPDATE CASCADE ON DELETE
CASCADE;
Kemudian ini untuk table bukti transfer, yg terjadi error tsb
CREATE TABLE "BKTTRANSFER"
(
"TGLBUKTI" DATE NOT NULL,
"NOBUKTI" VARCHAR(15) NOT NULL,
"GDGASAL" VARCHAR(15) NOT NULL,
"GDGTUJUAN" VARCHAR(15) NOT NULL,
"REMARK" VARCHAR(40),
"MIDOUT" NUMERIC(15, 0),
PRIMARY KEY ("NOBUKTI")
);
ALTER TABLE "BKTTRANSFER" ADD CONSTRAINT "FK_BKTTRANSFER_GUDANG" FOREIGN KEY
("GDGASAL") REFERENCES GUDANG ("KODEGDG") ON UPDATE CASCADE ON DELETE
CASCADE;
ALTER TABLE "BKTTRANSFER" ADD CONSTRAINT "FK_BKTTRANSFER_GUDANG" FOREIGN KEY
("GDTUJUAN") REFERENCES GUDANG ("KODEGDG") ; ------------> ini mas errornya
.....
----- Original Message -----
From: "sugi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 29, 2003 5:45 PM
Subject: RE: [Delphindo] 2 Foreign Key merujuk ke 1 Primary key
> > Wah kayaknya masih error nih, saya sudah nggak pakai cascade update &
> > delete, errornya spt ini Mas
> > 'Violation of FOREIGN KEY constraint "INTEG_12" on table "GUDANG"'
> > Gimana yah ?
> Coba posting script lengkap anda. Kalau sepotong sepotong kayak gini
> susah tracing-nya. Kalau tidak boleh dishow ke public, send private
> message to me. I'll see what I can do.
>
> Salam,
> sugi.
>
>
>
>
> Berlangganan: [EMAIL PROTECTED]
> Stop Berlangganan: [EMAIL PROTECTED]
> Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Looking for the latest Free IT White Papers?
Visit SearchSecurity.com to access over 500 white papers.
Get instant access at SearchSecurity.com Today
http://us.click.yahoo.com/.lAzoD/QLNGAA/witMAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
