Mungkin pak Teguh harus ngecek lagi segala yang berkaitan dengan tabel transaksi/detail transaksi tersebut, hal hal yang mentouch ke tabel tersebut seperti: a. Trigger b. Function/Prosedure c. Package d. Jobs e. Scheduled Concurrent f. Scheduled cronjob dll...
regards, adipt ----- Original Message ----- From: Teguh Susanto<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Thursday, August 20, 2009 8:04 AM Subject: External Email : --> Re: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... mungkin sy perjelas lagi masalah nya: spesifik table : 1. table transaksi (no_bukti,tgl_ transaksi, no_faktur) 2. table detail transaksi (no_bukti,kd_ item,qty, harga,no_ faktur) contoh transaksi #1 transaksi ('0001','2009- 08-01','F001' ); detail transaksi ('0001','ITM0045' ,2,5000,' F002'); //saat dientry jelas F001,tapi beberapa hari kemudian berubah menjadi F002 detail transaksi ('0001','ITM0025' ,1,7000,' F001'); detail transaksi ('0001','ITM0030' ,1,4000,' F001'); transaksi #2 transaksi ('0002','2009- 08-01','F002' ); detail transaksi ('0002','ITM0075' ,1,10000, 'F002'); detail transaksi ('0002','ITM0010' ,1,10000, 'F002'); --- Pada Rab, 19/8/09, Ahmad Jali <[email protected]<mailto:ahmadmj72%40yahoo.com>> menulis: Dari: Ahmad Jali <[email protected]<mailto:ahmadmj72%40yahoo.com>> Judul: Re: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... Kepada: [email protected]<mailto:indo-oracle%40yahoogroups.com> Tanggal: Rabu, 19 Agustus, 2009, 1:54 AM coba tolong di cek kembali no faktur di transaksi 1 dan 2 kalau di selectnya di detail transaksi, pasti akan ada 2 record. ____________ _________ _________ __ From: Teguh Susanto <teguh4milis@ yahoo.com> To: indo-oracle@ yahoogroups. com Sent: Wednesday, August 19, 2009 1:45:02 PM Subject: [indo-oracle] OOT:data transaksi sering menclok ke data transaksi lain... kepada Senior DBA&Miliser Oracle yg sy hormati saya pakai oracle 9i,saya sering kali dpt kompain dari user karena transaksi yg mrk lakukan sering ketambahan data sendiri atau ada detail transaksi yg hilang spesifik table : 1. table transaksi (no_bukti,tgl_ transaksi, no_faktur) 2. table detail transaksi (no_bukti,kd_ item,qty, harga,no_ faktur) contoh transaksi #1 transaksi ('0001','2009- 08-01','F001' ); detail transaksi ('0001','ITM0045' ,2,5000,' F002'); transaksi #2 transaksi ('0002','2009- 08-01','F002' ); detail transaksi ('0002','ITM0075' ,1,10000, 'F002'); jadi klo saya "SELECT a.* FROM detail_transaksi where no_faktur='F002' " akan tampil 2 record.. yang jadi pertanyaan kenapa hal tersebut terjadi? bagaimana solusinya? sebelumnya saya ucapkan terimakasih. .. regrads teguh "Coba Yahoo! Mail baru yang LEBIH CEPAT. Rasakan bedanya sekarang! http://id.mail. yahoo.com& quot; [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] __________________________________________________________ Coba emoticon dan skin keren baru, dan area teman yang luas. Coba Y! Messenger 9 Indonesia sekarang. http://id.messenger.yahoo.com [Non-text portions of this message have been removed] ________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. [Non-text portions of this message have been removed]
