kalo mau gitu text itemnya di set varchar aja... baru select to_char .... into :tgl_jual
cheers.. Erry --- Pada Kam, 26/11/09, Ruben Edson <[email protected]> menulis: Dari: Ruben Edson <[email protected]> Judul: [indo-oracle] Re: WTA: how to set datetime (now) in text item @ oracle form Kepada: [email protected] Tanggal: Kamis, 26 November, 2009, 3:38 AM Thank's Ibu Marina dan Bapak Murdi... btw, klo utk menampilkan waktunya (jam, menit dan detik) jg, gmn? ____________ _________ _________ __ From: marina <marina.christien@ gmail.com> To: indo-oracle@ yahoogroups. com Sent: Thu, November 26, 2009 2:38:53 PM Subject: Re: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle form Pak Ruben, kalau mau format tanggl yg panjang langsung saja gunakan tipe data datetime terus gak usah di kasi to_char. contoh :tgl_jual := sysdate; kalau mau menggunakan to_char ya tipe text itemnya haru char juga. semoga berhasil. Ruben Edson wrote: > > > Dear: All user indo-oracle > > bagaimana cara setting waktu di text item (:penjualan. tgl_jual) ketika > form pertama kali running? > > berikut ini codingnya: > saya buat trigger (When-New-Form Instance) di form > begin > select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into > :penjualan.tgl_ jual from dual; > end; > > dengan format field tgl_jual date, muncul error... > > mohon saran / masukan temans... Thanks a lot :D > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Selalu bersama teman-teman di Yahoo! Messenger. Tambahkan mereka dari email atau jaringan sosial Anda sekarang! http://id.messenger.yahoo.com/invite/ [Non-text portions of this message have been removed]
