Oke sudah dicoba dan berhasil, btw thx ya indra.
----- Original Message ---- From: Indra Armansyah <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, February 21, 2008 10:15:01 AM Subject: Re: [indo-oracle] Tanya tentang increment no. urut Coba ganti isi trigger WHEN-NEW-RECORD- INSTACE dengan: :LINE_NO := :system.trigger_ record; Semoga membantu. Salam, Indra Armansyah [EMAIL PROTECTED] com ----- Original Message ----- From: Gita cantiq To: indo-oracle@ yahoogroups. com Sent: Thursday, February 21, 2008 10:01 AM Subject: [indo-oracle] Tanya tentang increment no. urut Dear All Oracle Mania, Mo tanya lagi nih semoga ada yang bisa bantu yah, saya mau menanyakan mengenai cara increment no. urut pada block detail Ceritanya : Saya membuat form header dan detail (ada relasi antara header dan detailnya). Lalu di posisi detail ada no. urut yang harus bertambah setiap kita menambahkan detailnya. Jadi pada trigger WHEN-NEW-RECORD- INSTANCE, saya sudah menuliskan seperti ini : DECLARE recstat VARCHAR2(20) := :System.record_ status; BEGIN IF (recstat = 'NEW' or recstat = 'INSERT') THEN :line_no := :line_no + 1; END IF; END; Dimana line_no sendiri adalah field dari detailnya. Tapi kalau formnya di-run, field line_no tetap tidak terisi angka 1, 2, dst. Untuk jelasnya saya kirimkan file fmb.nya (no_urut1.fmb) Terima Kasih Gita ____________ _________ _________ _________ _________ _________ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] ------------ --------- --------- --------- --------- --------- - No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.9/1290 - Release Date: 2/20/2008 8:45 PM [Non-text portions of this message have been removed] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
