errornya apa mas..?

mungkin datatype untuk item :penjualan.tgl_ jualmasih dalam format date. kalau 
diganti ke varchar mungkin bisa.









________________________________
From: Ruben Edson <[email protected]>
To: [email protected]
Sent: Thu, November 26, 2009 2:25:28 PM
Subject: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle form

  
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]

Kirim email ke